Forced Parameterization, Meet Filtered Indexes
Forced Parameterization can be a useful setting to tune workloads, but this can work against you if you're also using filtered indexes.
Monthly Archive: September 2019
A quick tip when using multiple Docker containers and SQL Server
Give your Docker containers meaningful port numbers to avoid confusion, especially when presenting or giving demos.
Bad Habits to Kick : Avoiding the schema prefix
Originally published in 2009, I updated this in 2019 with an example showing an effect on the plan cache.
Materials from Music City Data
Aaron shares his slides and demos from his most recent delivery of T-SQL : Bad Habits and Best Practices.
Features and Fixes in SentryOne Plan Explorer 19.1.2
Read about the improvements in the latest version of SentryOne Plan Explorer, 19.1.2.
Another limitation of STRING_SPLIT
Did you know that not all characters can be used as the separator for STRING_SPLIT?