Blog

The execution plan is a gold mine of information about how your query performed. You can tell the steps that were taken, the number of rows that were processed, and even get index or statistics hint. But what isn’t the execution plan telling you? Jes will show things that you might not realize are problems – and how to fix them! 

Resources

Don’t Fear the Execution Plan [Video] 

Craig Freedman’s Parallel Query Execution Presentation 

Paul White’s Forcing a Parallel Query Execution Plan 

↑ Back to top
  1. Nice video! I would highly recommend http://statisticsioparser.com/statisticsioparser/ as well. This is especially useful when tuning larger queries.

    Also, nice job handling Jack Jack without losing your focus! :)

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

css.php