Guest Columnist: Nicholas Cain

One of the more exciting new features in SQL Server 2008 is data compression and Nicholas Cain talks a bit about how this works and how to determine if it fits in your environment.  Read more...

Fragmentation in SQL Server is a huge debate. Does it matter? How much is too much? What should you do? In any case, new author Nicholas Cain has put together a system that allows him to keep track of the levels of fragmentation as well as defragment those tables when he feels they are getting too spread apart.   Read more...