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

Content with tags Performance Tuning, Execution Plans Rss

   Items 1 to 7 of 7   
 

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 | 5,933 reads

Cursors for T-SQL Beginners

Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.   Read more...
By Wagner Crivelini 2011/05/27 (first published: 2009/01/01) | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 22,031 reads

Showplan Operator of the Week – BookMark/Key Lookup

Fabiano continues in his mission to describe the major Showplan Operators used by SQL Server's Query Optimiser. This week he meets a star, the Key Lookup, a stalwart performer, but most famous for its role in ill-performing queries where an index does not 'cover' the data required to execute the query. If you understand why, and in what circumstances, key lookups are slow, it helps greatly with optimising query performance.   Read more...
By Additional Articles 2010/05/25 | Source: SimpleTalk
Rating:  Rate this |   Briefcase | 2,156 reads

Ad Hoc Queries Don’t Reuse Execution Plans: Myth or Fact

Another frequently heard story is that stored procedures get and reuse execution plans, but ad hoc queries do not. A...  Read more...
By Grant Fritchey 2009/10/07 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,632 reads

Analyzing the SQL Server Plan Cache

Keeping in mind the importance of the cache mechanism, how could one get the plans and their usage statistics in SQL Server?  Read more...
By Additional Articles 2009/01/19 | Source: MSSQLTips.com | Category: execution plans
Rating: (not yet rated)  Rate this |   Briefcase | 3,566 reads

Graphical Execution Plans for Simple SQL Queries

Learning how to read and analyze execution plans takes time and effort. But once you gain some experience, you will find them an essential skill for getting to grips with performance issues in SQL Server Queries. Grant here describes the range of execution plans for different simple SQL Queries.  Read more...
By Additional Articles 2009/01/05 | Source: SimpleTalk | Category: execution plans
Rating:  Rate this |   Briefcase | 4,708 reads

Cursors for T-SQL Beginners

Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.   Read more...
By Wagner Crivelini 2011/05/27 (first published: 2009/01/01) | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 22,031 reads
   Items 1 to 7 of 7   
 
Tags
blogs (1)    
cursors (1)    
sql server 2012 (1)    
t-sql (1)