Execution Plans

Free eBook: SQL Server Execution Plans, Third Edition

  • Article

If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.

2019-06-12 (first published: )

119,575 reads

Changes to SQL Server 2012 Execution Plans

  • Article

I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most of them associated with new or different functionality. I had not noticed anything really fundamental until recently. I’ve become a huge proponent of always checking the properties of the SELECT statement. There’s so much useful information in there about what’s happened with the plan generation in the optimizer (not low level stuff, but the big picture items) that you should always be checking it first as a fundamental part of your plan examinations.

2011-12-14

6,689 reads

Free ebook: SQL Server Execution Plans

  • Article

This free book is brought to you by Red Gate Software and Simple Talk Publishing. Why my query is running slow? Why isn't my index getting used? In order to answer these questions, you have to ask the same return question in each case: have you looked at the execution plan? Grant Fritchey provides the only dedicated and detailed guide to this essential topic.

5 (1)

2011-07-11

6,178 reads

Blogs

Last Week Reading (2019-06-16)

By

Hello Data girls and guys! A lot of Microsoft’s announcements in many areas of...

Back with new focus

By

Back with a new focus First let me say wow can’t believe that it...

A Double Day

By

I’m traveling back from Australia today. A few weeks ago I lost a day...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Migration from server to server

By rrizzojr

I recently migrated from Windows 2003 SBS running SQL 2005 Express along with SSMS...

Temporary data and Differential Backup size

By Thomas Franz

Comments posted to this topic are about the item Temporary data and Differential Backup...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers