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.
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 containers meaningful port numbers 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?