Nicholas Cain

Nicholas Cain started out as the overnight grunt at the now defunct MicroWarehouse 3 years ago. There he got his first introduction to SQL Server where he found an interest and a little aptitude thanks to the help of some great workmates. He now works as a DBA at T-Mobile USA.

All authors

SQL Server 2008 and Data Compression

by Nicholas Cain

SQLServerCentral

SQL Server 2008

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.56 (27)

You rated this post out of 5. Change rating

2009-01-07

10,214 reads

Discuss

Checking Your Database Fragmentation Level

by Nicholas Cain

SQLServerCentral.com

Administration

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.