A subtle redirection
For this month's T-SQL Tuesday, I talk about an incident where I've changed my mind about something I was previously pretty stubborn about.
Find out how to use dynamic SQL to quickly generate metadata queries to pull attributes for all columns across a database or even a set of databases.
Forced Parameterization can be a useful setting to tune workloads, but this can work against you if you're also using filtered indexes.
Give your Docker container port numbers meaning to avoid confusion, especially when presenting or giving demos.
Originally published in 2009, I updated this in 2019 with an example showing an effect on the plan cache.
Aaron shares his slides and demos from his most recent delivery of T-SQL : Bad Habits and Best Practices.
Read about the improvements in the latest version of SentryOne Plan Explorer, 19.1.2.
Did you know that not all characters can be used as the separator for STRING_SPLIT?
Read about an approach to partitioning a result set without the performance impact of NTILE.
Find out what's in the SentryOne Plan Explorer extension for Azure Data Studio.
See how to work around the lack of an ALTER TYPE command.
Discover some of the new information SQL Server keeps adding to help us troubleshoot query plans.