Words to live by.

The scripts are better in ExEvents....

Oh, I hate disagreeing with people, but

NOOOOOOO!!!!!

Don't do this. Your procs (and all your...

Is the index unique? That can change the choices made by the optimizer even though the index isn't used in the plan. Otherwise, I'm with Lynn, test it, post the...

1. NO!!!!!!!! These are suggestions only.
2. There is no way, in the world, to correlate the information within the missing index DMVs with the queries on your system. This fact...

I'm not sure how far I'd go beyond:

Name

This is what it does, in short, clear, descriptive phrases

These are the parameters

These parameters are required

These parameters have default values and here they...

So, for actively running queries, I recommend the DMVs, sys.dm_exec_requests is a good starting point. You can join that to other DMVs to get the execution plan, the SQL statement...

Well, just in case you have more issues like this, I'd like to recommend my books. Query tuning is a pretty vast topic. Follow the links below.

Good article (and yeah, I know it's older, I just saw it). I'm a huge proponent of Extended Events, so it's awesome to see them getting promoted.

One note, the deadlock...

That feeling when you want to point out that someone isn't correct about what they said, but you don't want to derail a topic and / or...

That feeling when you want to point out that someone isn't correct about what they said, but you don't want to derail a topic and / or...

That feeling when you want to point out that someone isn't correct about what they said, but you don't want to derail a topic and / or annoy said...

STATISTICS_IO and TIME is not recommended to be kept ON at all the times as you rightly mentioned and should be immediately SET to OFF once we have the...

As for the queries being slow, check out the execution plan to see how the deletes are being derived by the optimizer. It's possible to tune deletes (sometimes). You may...

I advice to use the SET STATISTICS_IO ON and SET STATISTICS_TIME ON. It will give you simple yet meaningful info for optimizing your query or choosing the best performing...