May 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training

SQL SERVER – Getting Started with Execution Plans

August 27, 2010
Pinal Dave
SQL
Execution Plan

Execution Plans is one of the most interesting subjects and I often get a question about it. Many people want to know how to get started.

Read More

SQL SERVER – View XML Query Plans in SSMS as Graphical Execution Plan

July 3, 2010
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Execution Plan, SQL Scripts, SQL Server Management Studio, SQL XML
Earlier I wrote a blog post on SQL SERVER – Parallelism – Row per Processor – Row per Thread, where I mentioned the XML Plan. As a follow up on the blog post, I received the request to send the same execution plan so that the blog readers can also…
Read More

SQL SERVER – Execution Plan – Estimated I/O Cost – Estimated CPU Cost – No Unit

January 22, 2010
Pinal Dave
SQL Performance
Execution Plan, SQL Server

During the SQL Server Optimization training, I enjoy teaching the Execution Plan. I am always sure that questions related to the estimated cost will be raised by attendees. Following are some common questions related to costs:

Read More

SQL SERVER – Fix: Error: 262 : SHOWPLAN permission denied in database

January 5, 2010
Pinal Dave
SQL Server
Execution Plan, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security

During one of my recent training class when I asked students to check the execution plan using (can be enabled using CTRL+M), they received error as following.

Msg 262, Level 14, State 4, Line 1
SHOWPLAN permission denied in database ‘AdventureWorks’.

Read More

SQL SERVER – Actual Execution Plan vs. Estimated Execution Plan

August 28, 2007
Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
DBA, Execution Plan, SQL Scripts
I was recently invited to participate in big discussion on one of the online forum, the topic was Actual Execution Plan vs. Estimated Execution Plan. I refused to participate in that particular discussion as I have very simple but strong opinion about this topic. I always use Actual Execution Plan…
Read More
Previous 1 … 14 15 16 17
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2023 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version