MSSQLTips

One of my favorite features with SQL 2008 has been Data and Backup compression (which I discuss in more detail technically here ) - this is not only because of the actual functionality it brings to the table, but also because of all the technical intricacies that it involves and the impact it can have...

Given some of the "larger" features being introduced with Sql 2008 which are getting lots of coverage and attention (understandably so), there are actually quite a few "smaller" features that are included which will provide a great deal of benefit to SQL Server users everywhere -...