2022-04-27
398 reads
Data Compression
Estimating Data Compression Savings in SQL Server
This video demonstrates a set of queries for estimating data compression savings in SQL Server. It also covers how to make an informed decision on whether data compression makes sense for your data and workload or not.
2021-10-08
2021-09-10
500 reads
2021-09-03
487 reads
2020-11-24
505 reads
2019-03-25
190 reads
2017-11-13
940 reads
Data Compression and Snapshot Isolation
Data Compression and Snapshot Isolation don't play well together, you may not see a performance benefit
2014-10-02
3,655 reads
Demonstrating the Effects of Using Data Compression in SQL Server
How much space would compressing a particular index will save? How will this affect query performance? Derek Colley walks you through the effects of using data compression in SQL Server.
2014-03-25
4,651 reads
2013-01-30
2,192 reads
Blogs
Enabling an Index: #SQLNewBlogger
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Forums
How are statistics stored?
Comments posted to this topic are about the item How are statistics stored?
Where's the Printer Friendly Option?
Comments posted to this topic are about the item Where's the Printer Friendly Option?
Switch from MSSQL SVC to MSA - Unable to start services
Using MSSQL 2019 standard edition It was installed using SVC Account. But now I...
Question of the Day
How are statistics stored?
How are the statistics for query optimization stored in SQL Server?
See possible answers