Media Summary: I nearly always use execution plans as the starting point for When the phone rings, you need a repeatable process to discern the symptoms, root cause, what will happen if you don't take ... You're comfortable writing queries to get the data you need. But you're UNcomfortable if someone asks you how it works, how ...
How To Triage Sql Server - Detailed Analysis & Overview
I nearly always use execution plans as the starting point for When the phone rings, you need a repeatable process to discern the symptoms, root cause, what will happen if you don't take ... You're comfortable writing queries to get the data you need. But you're UNcomfortable if someone asks you how it works, how ... You're comfortable writing queries to get the data you need. But you're uncomfortable if someone asks you how it works, how In this video, I demonstrate how to configure Microsoft Brent's session at Microsoft Ignite 2015 in Chicago. He covers trace flag 4199, columnstore indexes, scaling out to AG ...
Additional resources - Download & install Microsoft Brent Ozar demos the new ADR feature that enables instant rollbacks by storing past versions of your rows inside the database.
