Wow, busy week this week.
How I Get By Without Sysadmin: Jeremiah Peschka has a great article on tuning queries from a developer’s perspective. I’ve been a big advocate of some of his methods for a while now, and it’s nice to see other people come to some of the same conclusions that I have.
Index Clean-Up Scripts: It seems like I’ve beeen reading a lot about performance tuning and maintenance issues; you’re right. I’m sudying for the upgrade to my MCDBA (MCITP), and a lot of my maintenance skills are rusty. Posts like these are very interesting and help to keep the skills in check.
To be honest, I haven’t read a lot of technical sites this week; too worried about what’s going on with this joke of a stimulus package. I’ll do better next week, I promise 🙂
There are versions of Michelle’s scripts specifically tuned for both standard edition and enterprise edition of 2005/2008 available at http://sqlserverpedia.com/wiki/Index_Maintenance
We use them on both our development and production servers and they run like a dream in an incredibly short amount of time.