Link dump:
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL).
SET SHOWPLAN_ALL (Transact-SQL).
SET SHOWPLAN_XML (Transact-SQL).
SET SHOWPLAN_TEXT (Transact-SQL).
Displaying Graphical Execution Plans (SQL Server Management Studio).
SQL Server Management Studio Tip: Show Execution Plan – Robert Burke’s MSDN Weblog – Site Home – MSDN Blogs.
Just press ctrl + m in SQL Server Management Studio to activate “Include Actual Execution Plan”. This will show the real execution plan just as with any ordinary query.
via Getting query / execution plan for dynamic sql in SQL Server – Stack Overflow.
SET SHOWPLAN_TEXT cannot be specified when using a stored procedure
You need to have the SHOWPLAN permission while running SET SHOWPLAN_TEXT
via How to quickly analyze a slow running query using SHOWPLAN_TEXT.
SqlMag.com: Understanding Query Plans.
Chapter 1 of “Dissecting SQL Server Query Plans”: Execution Plan Basics.
How To: Optimize SQL Queries.
–jeroen
Filed under: Database Development, Development, SQL, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 
