A reader’s swap puzzle solution used SOUNDEX, so many asked how it works. I explain the SOUNDEX function and DIFFERENCE function with simple examples.
Building a Reference You Will Actually Use Again
Build a personal reference of dependable SQL examples with problem-based names, clear prerequisites, dated validation, and regular review.
SQL SERVER – Solution of Puzzle – Swap Value of Column Without Case Statement
Readers sent more than 50 answers to my swap puzzle. Here are 5 different ones that swap a column value without CASE statement, plus my own three.
SQL SERVER – Video – Beginning Performance Tuning with SQL Server Execution Plan
Performance tuning is a long journey, and the Execution Plan is its map. A video on how to begin tuning queries with SQL Server execution plans.
SQL SERVER – A Quick Look at Logging and Ideas around Logging
What comes to mind when you hear logging? I asked five SQL Server friends and got five answers, from the OUTPUT clause on. Here are our ideas around logging.
An Error Handling Template for Stored Procedures With THROW
Build an error handling template with XACT_ABORT, XACT_STATE, durable error logging, and THROW, then test a forced procedure failure.
SQL SERVER – Finding Size of a Columnstore Index Using DMVs
This script uses sys.indexes and sys.dm_db_partition_stats to list the size of a columnstore index on disk, along with its table name.