She Can Dig It!

A few PASS Summit’s ago, I became interested in the information available in the Plan Cache.  As part of that interest, I started digging into the plan cache to  find out what is there and available to be pulled out.

Some of those investigations led to a few presentations; which have in turn led to this blog series.  Rather than number these out and put a timeframe around them, I’ve instead opted to post here are there when I have new plan cache queries and to publish information from my presentations.

The posts in this series to date are:

• The Plan Cache
• Parallelism in the Plan Cache
• Missing Indexes
• SHOWPLAN XML Structure
• StmtUseDb Element
• StmtCond Element
• StmtCursor and StmtReceive Elements
• StmtSimple Element
• Find Estimated RowCounts
• Find Estimated Cost
• Researching Index Scans

As more posts are published, I’ll add them to this list.  Enjoy digging into your plan cache.

Related posts:

1. Can You Dig It? – The Plan Cache
2. Can You Dig It? – Parallelism in the Plan Cache
3. Can You Dig It? – Determining Index Plan Usage
4. Can You Dig It? – SHOWPLAN XML Structure
5. Can You Dig It? – StmtUseDb Element