SQL Server

When it comes to databases, size really does matter, and for many reasons.Clients often just consider the storage cost of the main database but they should think about much more than that. I read recently that a typical organization held more than 40 copies of its primary database in various guises: copies in other environments (UAT, Staging, Testing), many backup copies, etc. There is also a larger management cost associated with a larger storage volume.With ROW compression, SQL Server makes changes to how the contents of a row is stored to ensure that more rows fit on a single page. Clients are often surprised that this can increase the performance of their applications but there are several reasons.

byGreg Low