Getting the plan handle for a sproc

You can use this T-SQL to get the plan handle for a sproc that has a bad execution plan:

Make sure, to…

Viewing the execution plan for a specific Sproc

Views – 411

Execution Plan Notes

Clustered Index Seek: performed where there is a WHERE clause and the search parameter is included in the clustered index. Clustered Index Scan:…

SQL Server 2012 Internals

Life Cycle of a Query The command parser evaluates the query and generates a hash to see if the buffer pool has an…