2016-04-29
1,350 reads
2016-04-29
1,350 reads
This will log output of estimate compression for both PAGE and ROW for all tables and indexes
2015-12-10 (first published: 2015-11-20)
1,656 reads
A start at identifying and creating TSQL statements for tables that may benefit from compression.
2011-01-13
4,519 reads
This article attempts to show a practical scenario on improving DB design and performance through row density and compression in Microsoft SQL Server 2008.
2010-11-18
8,998 reads
2010-09-03
3,262 reads
This script creates scripts to compress all tables and indexes in a database.
2010-01-04 (first published: 2009-12-11)
12,284 reads
Thanks Phil for the Solution, I am using this and its working with my Query
2004-10-06
Would executing a transaction log from several days of prod activity against the test database work to simulate this load? Just a thought. I'm still confused on how to simulate the traffic since there are updates/inserts/deletes.
2004-08-30
Saw your note yesterday at home, our Brian is supposed to be checking! Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-10-08
1 reads
quote: having to key in all the column names. Call me lazy! [:) Don't key them, use the object browser to drag them over - taking the columns folder gives you all the columns in one drag 🙂
2003-07-25
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers