Execution Plan Archives - Page 18 of 18 - SQL Authority with Pinal Dave

Apr 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

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’.

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…