CREATE DATABASE

One of the biggest pain points for SQL Server 2000 was for looking at the plan of a SQL Statement, you have to execute the same. As per my understanding SQL Server 2000 did not expose any mechanism for this. So the only way to look at the plan of the Read More...

In my previous post http://blogs.msdn.com/gauravbi/archive/2005/12/01/BufferPoolDesc.aspx we talked about analyzing the contents of buffer pool. Let's talk a bit about analyzing the contents of procedure cache- First we need to figure out what are the Read More...