Tag Archives: SQL 2008

How is Fill Factor Impacting My Indexes?

The theme for this month’s T-SQL Tuesday is indexes so it seemed like the perfect excuse to blog about a script that I have written to see what choices for fill factors on indexes actually does to the structure of those indexes. Continue reading

Posted in Utilities | Tagged , , , , , , , | 13 Comments

Great News! SSMS Tools Pack 1.9 is Coming Out!

Mladen Prajdic recently announced that the newest version of SSMS Tools Pack is coming out and I am excited.
Continue reading

Posted in Utilities | Tagged , , , , , | 2 Comments

Why Do My SQL 2008 Compressed Backups Shrink?

Recently a coworker was doing some research with SQL 2008 Backup Compression on a very large database. During the testing they noticed that the backup file shrunk rather than grew. It turns out this behavior is intentional and beneficial. Continue reading

Posted in Backup | Tagged , | 3 Comments