Brent Ozar

#88 add SET STATISTICS XML OFF to stop showing actual plans

1

Closes #88.

SET STATISTICS XML OFF to avoid getting sp_WhoIsActive's execution plan

3

Every now and then, I accidentally run sp_WhoIsActive in a window with actual plans turned on. Putting SET STATISTICS XML OFF at the top just disables the actual plan output....

**Version of the script** SELECT @Version = '8.09', @VersionDate = '20220408'; **What is the current behavior?** In database compat levels 150 (2019) and prior, if you run sp_BlitzCache, you can...

In v1.4 and v1.5. More info later.

sp_BlitzIndex: remove psychological terms

1

When we first wrote sp_BlitzIndex, we used psychological terms to describe indexes. Wording like "Self Loathing", "Abnormal Psychology", and "Aggressive Indexes" was confusing, though, and always required a lot of...

Easier troubleshooting for forced plan failures

1

**Is your feature request related to a problem? Please describe.** The "Automatic Tuning" (aka regressed plan forcing) in Azure SQL DB & SQL Server can go awry, leaving behind plan...

**Is your feature request related to a problem? Please describe.** I've had a couple of underpowered Azure SQL DB clients recently, and I wanna make it easier to see at...

**Is your feature request related to a problem? Please describe.** A few different related issues: * The plan cache, query workspace, In-Memory OLTP, or memory-optimized TempDB consumes a large amount...