CREATE DATABASE

Quest in Database design

Browse by Tags

Tagged Content List
  • Blog Post: Graphical Representation of XML Plan

    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 query was to capture the queries used by application...
  • Blog Post: Procedure Cache Analysis

    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 plans present in the cache after a scenario...
Page 1 of 1 (2 items)