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:
SQL SERVER – Fix: Error: 262 : SHOWPLAN permission denied in database
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
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