Wait Statistics on a Query

Wait statistics are a vital part of understanding what is causing your system to run slowly. Capturing them can be...

Database Fundamentals #16: Removing Data With T-SQL

Deleting data from a table using T-SQL works quite a lot like the UPDATE statement.

How it Works
In the same way...

Youtube Channel Update

Hello,
I just wanted to take a moment to promote the work I’ve been doing with the YouTube Channel.
I’ve published four...

Getting Started in a SQL Server 2017 VM in Azure

You say you’re ready to dip your toes in the Azure ocean? Come on in, the water’s fine!
Oh, you want...

You Need a New Hobby

Not sure who this is that is attempting to hack into my blog so desperately, but seriously, time for a...

It's an Exciting Time

I read a lot of history (as you no doubt notice from my other editorials). I’m currently reading an excellent book on the air war in World War One, Marked for Death: The First War in the Air. One of the fascinating aspects of the war is just how fast the technology shifted. At the […]

Statistics Use, Extended Events and Execution Plans

Query tuning ain’t easy.
Figuring out which index is getting used is one step, and generally simple, look at the execution...

Updated YouTube Channel

Hello all,
I’ve recently updated my YouTube channel. I’m going to be posting a lot more videos up there. If you...

Snow, Heathrow Airport, Disaster Recovery

I recently flew from Boston to the UK through the Heathrow airport. It just happened to be on the day...

Execution Plan Metrics and Units of Measure

Have you ever looked at the properties inside an execution plan and wondered what the units of measure were? I...