SQLServerCentral.com Articles tagged Execution Plan

sp_prepexec and nHibernate

Thu, 08 Dec 2011 07:00:00 UT

SQL Server architect David Poole sets about exploring sp_prepexec when called from nHibernate.

Cursors for T-SQL Beginners

Fri, 27 May 2011 06:00:00 UT

Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.

ShowPlan Operator of the Week - Split, Sort, Collapse

Fri, 22 Apr 2011 06:00:00 UT

'Split, Sort & Collapse' is, happily, not a description of the intrepid Fabiano Amorim after his epic series of articles about the ShowPlan operators. With renewed stamina, Fabiano continues his mission to describe all the major operators by explaining the Trivial Plan and the power of unique indices.

Showplan Operator of the Week – SORT

Wed, 03 Nov 2010 06:00:00 UT

Fabiano introduces another ShowPlan operator that is used to build a query plan, or perform an operation specified in the DML. Once again, Fabiano demonstrates why it is important to be aware of these operators when getting queries to perform well.

Physical Join Operators in SQL Server - Hash Operator

Mon, 12 Jul 2010 06:00:00 UT

In the concluding part of the Physical Operators series we look at the Hash operator.

Physical Join Operators in SQL Server - Merge Operator

Mon, 05 Jul 2010 06:00:00 UT

Part II of the Physical Joins series looks at the Merge operator.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Operator of the Week - Lazy Spool

Mon, 28 Jun 2010 06:00:00 UT

Continuing to illuminate the depths of SQL Server's Query Optimizer, Fabiano shines a light on the sixth major Showplan Operator on his list: the Lazy Spool. What does the Lazy Spool do that's so special, how does the Query Optimizer use it, and why is it so Lazy? Fabiano Amorim explains all.

SQL Server Execution Plans

Tue, 10 Feb 2009 13:03:02 UT

Every day, out in the SQL Server forums, the same questions come up again and again: why is this query running slow? Why isn't my index getting used? In order to arrive at the answer 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 book on this essential topic.

Analyzing the SQL Server Plan Cache

Mon, 19 Jan 2009 07:00:00 UT

Keeping in mind the importance of the cache mechanism, how could one get the plans and their usage statistics in SQL Server?

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Graphical Execution Plans for Simple SQL Queries

Mon, 05 Jan 2009 07:00:00 UT

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.

Cursors for T-SQL Beginners

Fri, 27 May 2011 06:00:00 UT

Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.