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.
SQL SERVER – View XML Query Plans in SSMS as Graphical Execution Plan
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
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