07 October 2009

  • 23

  • 9467 views

  • 0

07 October 2009

9467 views
23 0

SQL Server Execution Plans – eBook Download

Why is my query 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. Download the eBook.

821-ExecutionPlansCover.jpg

“Every day, out in the various SQL Server forums, the same types of questions come up again and again: why is this query running slow? Why isn’t my index getting used? And on and on. 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, Author.

SQL Server Execution Plans (link to eBook download – 12MB)

Table of Contents

  • Chapter 01: Execution Plan Basics
  • Chapter 02: Reading Graphical Execution Plans for Basic Queries
  • Chapter 03: Text and XML Execution Plans for Basic Queries
  • Chapter 04: Understanding More Complex Query Plans
  • Chapter 05: Controlling Execution Plans with Hints
  • Chapter 06: Cursor Operations
  • Chapter 07: XML in Execution Plans
  • Chapter 08: Advanced Topics

Book Details

  • Paperback: 250 pages
  • Publisher: Red Gate Books

Redgate SQL Monitor

SQL Monitor helps you manage your entire SQL Server estate from a single pane of glass. Proactively mitigate potential risks with instant problem diagnosis and customizable alerting – wherever your databases are hosted. No downtime, customer complaints, or wake-up calls at 3am.

Find out more

  • 23

  • 9467 views

Rate this article

Click to rate this post!
[Total: 2 Average: 4]

Grant Fritchey

Grant Fritchey is a Data Platform MVP with over 30 years' experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. Grant volunteers for PASS and is on the Board of Directors as the Immediate Past President. He joined Redgate Software as a product advocate January 2011.

Follow Grant Fritchey via

View all articles by Grant Fritchey

Load comments

Related articles

 24 May 2011
24 May 2011

SQL Server Backup and Restore for the Accidental DBA

0
59
Not everyone who is tasked with the job of ensuring that databases are backed up, and easily restorable, consider themselves to be database administrators. If you are one of these 'Accidental DBAs' then Grant Fritchey has some good straightforward advice for you to ensure that things go well when a database has to be restored from backups … Read more
0
59

Tags

, , , , , ,