2019-03-25
189 reads
2019-03-25
189 reads
2017-11-13
940 reads
Sharing our experience using Data Compression as a space savings option in MS SQL Server 2008
2018-10-19 (first published: 2016-01-18)
4,202 reads
Data Compression and Snapshot Isolation don't play well together, you may not see a performance benefit
2014-10-02
3,599 reads
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-12-17
1,602 reads
2013-11-13
1,722 reads
2013-01-30
2,189 reads
In my last tip, I shared some ideas for determining if you should consider breaking up the e-mail addresses you're storing, even putting the domain names in a separate table. I performed storage and timing comparisons for working with 10,000 unique e-mail addresses, but I completely ignored data compression. I wanted to revisit the same test case and apply data compression to the tables and see how that impacted the outcome.
2012-04-26
4,884 reads
A lot has been written about the potential performance benefits of SQL Server data compression; but hard performance data? Not so much.
2012-03-05
256,665 reads
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Hi friends, So I have a Login to a server that is a windows...
We recently had to rebuild servers that were configured with AG. I built everything...
Hi there I have a problem with a dynamicSQL Statement. In this code, I...