Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, Performance Tuning, SQL Server 2012 Rss

   Items 1 to 1 of 1   
 

Changes to SQL Server 2012 Execution Plans

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.  Read more...
By Grant Fritchey 2011/12/14 | Source: SQLServerCentral.com | Category: execution plans
Rating: (not yet rated)  Rate this |   Briefcase | 6,031 reads
   Items 1 to 1 of 1