Blog

Have you ever been curious about how SQL Server returns the results of your queries to you? Have you ever opened an execution plan but been bewildered by the results? Have you dabbled in query tuning, but weren’t sure where to focus your efforts? Join Jes as she takes you through the basics of execution plans. She’ll show you how to read them, how to spot common problems, how to spot help, and tools that will make your job easier.

Learn More in Our Execution Plan Training

Our How to Read Execution Plans Training explains how to get an execution plan, how to read the operators, and learn solutions to common query problems.

↑ Back to top
  1. Hey Jess, thanks a lot for this webcast. Today i’ll be brave enough to take a look at the execution plan, for a newbie like me this webcast was a great help. waiting eagerly for your next webcast on this.

  2. Hi Jes,

    I was wondering about how SQL decides to use a specific join type. You mentioned that it is based on the size of the result set. Is that the sum of the result sets from both tables? Or is it an average across all the tables involved in the join or something else?

    An example would be: if you are joining a table with 100 rows to a table with 10,000 does it think well I have to join 10100 rows so I’ll use this join type or does it say one of the tables has 10,000 rows so I’ll use this type or am I missing something completely?

    Thanks

  3. Does the plan cache only contain estimated plans?

  4. Pingback: (SFTW) SQL Server Links 28/03/14 • John Sansom

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