What keeps clearing my query stats?

I was building out a blog post about cardinality today and noticed that sys.dm_exec_query_stats was getting cleared my my Surface...

Query Tuning 101: Debugging a procedure

I was recently asked to help tune a stored procedure that has been historically taking between 55 and 60 seconds...

Query tuning 101: How to measure Query Plan I/O cost

If you’re a DBA or a developer chances are you’ve looked at a query plan or two. While looking at...

Query tuning 101: Problems with IN ()

If you’re a DBA or database developer, chances are you will have to write or rewrite queries from time to...

Why Halloween slowed your queries

Let me start by saying that this isn’t your typical post about the Halloween problem. This is intended to describe...

Thank you to @MrDenny

I wanted to take a quick moment to thank Denny Cherry for selecting me for Speaker Idol this year.

For...

Why I don’t love SELECT INTO

Long ago there were locking / blocking problems with the SELECT INTO statement. That’s not the case anymore and for AdHoc...

Read this before using SQL 2016 Temporal Tables

I’ve been testing the new Temporal Tables feature over the past day to see about using it in one of...

A quick note comparing ISNULL vs COALESCE

There are hundreds of blogs that compare the T-SQL ISNULL function with the ANSI standard COALESCE function. There are also...

Off-topic: If you’re in Texas and 18+ yrs old

Today is the last day to register to vote in Texas. I’m not sure about other states in the US...