Tag : trace flags - SentryOne Team Blog

Tag: trace flags

Paul White : Properly Persisted Computed Columns

Paul White : Properly Persisted Computed Columns

Paul White (@SQL_Kiwi) walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries involving computed columns.

SQL Server Optimizer Secrets With Trace Flag 86xx

SQL Server Optimizer Secrets With Trace Flag 86xx

Kevin Kline (@kekline) provides his slides and scripts from his new SQLBits session describing the deep internals exposed by the 86xx series of trace flags.

Erin Stellato : Trace Flag 2389 and the new Cardinality Estimator

Erin Stellato shows the combined effect of different versions of the cardinality estimator and trace flag 2389 on an ascending key model.

Tracing usage of trace flags

After a presentation at SQLintersection, Aaron Bertrand (@AaronBertrand) shows how to monitor when users are turning trace flags on and off.