2020-11-24
482 reads
2020-11-24
482 reads
2019-03-25
184 reads
2017-11-13
934 reads
Data Compression and Snapshot Isolation don't play well together, you may not see a performance benefit
2014-10-02
3,447 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-01-30
2,184 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
2011-08-09
2,052 reads
Making it easier to handle huge data sets
2010-01-18
2,682 reads
Data compression is a key feature with SQL 2008. This script, can compress all DB objects (partition/non-partitioned) according to Partition Range you specifiy.
2009-11-18 (first published: 2009-11-05)
1,123 reads
By Andy Warren
I think our profession was the better for having a professional association, even if...
By Andy Warren
in my last post I wrote about thinking of the tools as being a...
By Devin-Knight
There are a lot of hot phrases you’ve likely heard thrown around during various...
Anyone have a guide on how I migrate SSIS from sqlserver 2008 / 2012...
From our software provided by a third party vendor, I am seeing the following:...
This may be a bit non-typical, but I am currently running SQL 2019 Developer...