The COMPRESS() TSQL Function in SQL Server 2016+
Category:
sql-server
One cool little feature in SQL Server 2016 is COMPRESS(). It’s a TSQL function available in all editions that shrinks down data using the GZIP algorithm (documentation).
Desktop Wallpapers and Webcasts on Isolation Levels and Memory
Category:
database-administration
I’ve been having lots of fun drawing and doing webcasts this summer. I’ve got four SQL Server themed desktop wallpapers to share, and I’ve got lots more coming– along with a new chunk of free webcasts.
Downloadable SQL Server Desktop Wallpapers
Category:
database-administration
Get ’em here
Grab wallpapers at https://github.com/LitKnd/littlekendracomments/tree/main/SQLWorkbooks-Wallpaper-and-Posters.
Did that Query Eliminate Partitions? (videos)
Category:
query-performance
Table partitioning makes execution plans a bit more confusing.
Free Course
I have a free online course which walks you through decoding execution plans, including whether or not partition elimination occurred.
IF Statement Branching and Parameter Sniffing
It can be tricky to remember that SQL Server doesn’t short circuit on IF statements in stored procedures. Even when you know this, sometimes it’s hard to recognize the impacts.
Index Rebuild, Reorganize, and Statistics in Maintenance Plans in SQL Server 2016
Category:
maintenance
, statistics
Working with maintenance plans is supposed to be easy, but I find it to be quite difficult.
New Free Webcasts on Interviewing and Indexing
Category:
query-performance
Sharpen your performance tuning and indexing skills this summer, for free, one week at a time!