Well, we’re just back from vacation (photo blog post to follow) and I’ve heard that the feature article on Effective Database Maintenance I wrote for the August issue of TechNet Magazine is live on the web. It also includes a 5 minute long screencast I recorded where I demo the effect of database shrink on index fragmentation. You can get to the article at http://technet.microsoft.com/en-us/magazine/cc671165.aspx. The topics covered are: It’s written around 2-300 level and presents a good overview (well, at least I think so :-)) of the concepts involved. Also, the August SQL Q&A column is available at http://technet.microsoft.com/en-us/magazine/cc671180(TechNet.10).aspx. This month’s topics on the web (more in the print magazine) are: Enjoy!
Paul S. Randal
In Recovery...
2 Responses to TechNet Magazine: Effective Database Maintenance article and August SQL Q&A column
[...] and be done with it? No? Ok – how about go checkout the article I wrote last August for TechNet Magazine: Effective Database Maintenance article. If you don't maintain your indexes, they'll likely get fragmented and affect performance [...]
[...] one does. Here’s a link to the blog post that pulls all of the TechNet resources together: http://www.sqlskills.com/blogs/PAUL/post/TechNet-Magazine-Effective-Database-Maintenance-article-and… [...]