Extended Events are a very useful way of gathering and analysing Query Plans on a live SQL Server. So how can we use them?
When the going gets rough, SQL Trace can be a helpful way of discovering and retrieving those elusive query plans. This is how we can do it.
Oh, how can I capture query plans from thee, SQL Server? Oh, let me count the ways…
In How Can Query Plans Help Us?, we looked at the nature of T-SQL and then at some of the
In T-SQL Query Plan Analysis Prelude we looked at some common reasons why queries can sometimes go on a snail
Have you ever found yourself pulling your own hair with both hands, desperate to understand why that stubborn T-SQL query
Sometimes I feel really lazy. I’m just tinkering with a proof of concept database, a decent amount of test data,