2018-11-06
683 reads
COMPRESS()
2018-10-29
694 reads
Compress and Decompress in SQL Server 2016
Explore using Compress/Decompress with varying types of data and examine size/storage usage
2018-10-01
3,635 reads
2018-02-12
892 reads
2016-10-21
984 reads
Script to Compress Tables and Indexes
This script creates scripts to compress all tables and indexes in a database.
2010-01-04 (first published: 2009-12-11)
15,499 reads
Blogs
SQL Server Source Control on a $0 Budget
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
CHOOSE’ing a Beer: #SQLNewBlogger
By Steve Jones
We recently published an article on CHOOSE at SQL Server Central. I thought it...
Don’t Treat Your Data Catalog Like a Data Museum
Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...
Forums
Fantasy Football 2025
The thread for the league in 2025. Players from last year have priority.
String or Binary Truncation Error Strange Behavior (SQL 2019)
Forgot I posted a similar issue back in 2020, String or Binary Truncation Error...
Transactional Replication from Read replica
If I have Read replica (in Azure SQL MI), can it be used as...
Question of the Day
Replacing a Null
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers