SQL Server Query Tuning Best Practices - Part 1

SQL Server MVPs Aaron Bertrand and Kevin Kline begin their series on query tuning best practices. They go over some tips and tricks for writing queries. First, Kevin goes over query tuning methodology and what is needed to measure query performance. Then, Aaron discusses Default Cursors, Correlated Sub-Queries, and Not In.

Find more information about our products:

[shanem]

A great resource for the community to share. As a small contribution CXPACKET stands for class (as in C++ class) exchange packet and not context extension packet as mentioned at 20:11.

[briangalebmg]

very good video.  Learned a lot about queries.  I know where I work, cursors are used.  The majority of the time, I think that they are being used properly, but from my testing, I find that storing stuff in temp tables is faster than a cursor.  With SSIS though, sometimes that isn't a good or valid option.
Definitely going to be grabbing the tools you mentioned.  The timing couldn't be better.  We have recently had a few queries eating up a lot of CPU and/or high number of waiting tasks and high number of batch requests per second (IIRC, it got up to 250 today).  Watching the activity monitor, it got filled with cursors.
So I'd like to run your tool against one of our test DB's and see what it tells me.

[ArshakNorsoyan]

You, Guys are just awesome. This is so useful. Thank you so much to share this video!  .

[arunkumarg]

Thanks kevin and aaron may i know where can i get sqlsentry sample database pls help me

[Joe_DeSantis]

@SQLSentry is there a link to where I can find the queries used in the first 30 minutes of the presentation?

[sid]

So we can use Wait stats in Production?

[elenelenaelena]

first 7 min 15 sec - empty bla- bla- bla

[khushabhthakar]

clearly not done by someone who knows how to keep the watcher hooked. so much talk omg