Enabling Data Compression – February 2014 Update

Blog reader cp spotted a pretty big bug in the last version of this routine. Namely, non-clustered indexes were being flagged as no longer present and were therefore not being compressed. This was because the existence check I used, supplying an ID to OBJECT_ID() and checking for a NULL value, will always return a null […]

Enabling Data Compression – October 2013 Update

Note: For more details about this script and the variables and outputs, see my post here. I’ve made two changes to my script that checks for new database objects to compress. First, it will now enclose table and index names in square brackets to prevent errors with object names that are also keywords or include […]

Enabling Data Compression – August 2013 Update

[UPDATE Oct 2013]: I have made some improvements to this script, including those mentioned in the comments below. See my post on 10/28/13 for the latest version.   I recently posted an update of my script to enable data compression in SQL Server, but I’ve made some significant changes recently and decided it was time to […]

Enabling Data Compression In SQL Server

SQL 2008 saw the introduction of data compression to SQL Server. (I’m referring specifically to data compression, not backup file compression.) This Enterprise-only feature allows SQL Server to store data on disk and in memory in a compressed format. SQL can perform three types of data compression – no compression, row compression, or page compression. […]