2018-11-06
680 reads
COMPRESS()
2018-10-29
691 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,141 reads
2018-02-12
888 reads
2016-10-21
979 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)
14,221 reads
Blogs
A New Word: Ghough
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
Forums
Need to output table data into multiple CSV files
Hello, I created the below script to output 999 rows from SQL Server table...
Changing Database page Verify on a Database in an AG
I have a database on SQL 2019 in an Availability Group (AG) and I...
Alwyason availability group can set primary role permanently?
Hi. Two node windows clusters Node1 and Node2 and configured alwayson availability group. Will...
Ask SSC