Undoing compression

T-SQL Compression

Compress and Decompress in SQL Server 2016

Explore using Compress/Decompress with varying types of data and examine size/storage usage

Getting the Data Back

SQL 2016 COMPRESS

COMPRESS

UP_COMPACTA_COPIA

I have several problems with my corporate network and therefore need to do all my backups locally, and to make matters worse, still use SQL Server 2005.

Script to Compress Tables and Indexes

This script creates scripts to compress all tables and indexes in a database.

RE: Using xp_smtp_sendmail on 64-bit SQL Server

Thanks Mike.  We are also moving to 64-bit Itanium servers and are in the process of testing everything out.  I have moved away from XP_smtp_sendmail and have started using cdonts.  The change was quiet simple but thanks for offering the help.I do not think we will be using full-text indexing but would like to research it […]

Overhead of implicit data conversions with Unicode

We are working on a large commercial site that is going to be supporting Unicode in the future.    Part of the architecture is to have countries requiring Unicode to be in one Unicode environment and countries not requiring it to be in a nonUnicode environment.But the issue is around a common code base between the two.    […]