2022-04-27
397 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
497 reads
2021-09-03
482 reads
2020-11-24
504 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,632 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,190 reads
Blogs
Penetration Testing your SQL Server, Part 1 – The Recon Mission
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
SQL Saturday Denver 2023–VCS Primer for the Database slides
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
Future Data Driven 2023 is This Week
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Forums
cost threshold for parallelism value to be set
Hi Everyone, Why and when should be set 'cost threshold for parallelism'? We are...
Master Data - Relational or Dimensional modeling?
Dears, In my company, we have certain master data domains like customer; Vendor; Product;...
Convert columns result into rows with comma and single quotes
Hi All, Hi All, I want to convert columns result into rows with comma....
Ask SSC