2022-04-27
407 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
510 reads
2021-09-03
497 reads
2020-11-24
509 reads
2019-03-25
198 reads
2017-11-13
948 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,691 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,202 reads
Blogs
T-SQL Tuesday #191: Invitation–Your Favorite String Parsing
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Forums
The Improvement Limit
Comments posted to this topic are about the item The Improvement Limit
Migrate SSRS Reports to a New Server in Just a Few Clicks
Comments posted to this topic are about the item Migrate SSRS Reports to a...