data-konzept

'SQL Server supports row and page compression on tables, indexes and partitions. This can lead to reduced I/O and better performance. However, it can also result in additional CPU usage in some cases, outweighing the benefits of data compression. SQL Server query optimizer does not cost the overhead of expanding the compressed data, which can lead to plan regression as shown in the video.

The below video demonstrates this with hands-on example. The video also provides the hands-on scripts. You can practice the online hands-on example while watching the video.'...

http://www.sqlservercentral.com/blogs/ramesh-meyyappans-sql-server-performance-tuning-blog/2016/05/10/data-compression-in-sql-server-pros-and-cons/