Can You Dig It? – StmtSimple Element

We’re up to the seventh post on the in the plan cache series.  This time we’ll be talking about the last of the possible children for the Statements elements – the StmtSimple element.  StmtSimple, commonly referred to as statement simple, can contain the plan information for a query plan, a store procedure, or a user … Continue reading Can You Dig It? – StmtSimple Element

Can You Dig It? – StmtCursor and StmtReceive Elements

Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt A few posts ago in the plan cache series I discussed the children for the Statements element.  I’ve gotten through two of the elements and in this post we’ll be … Continue reading Can You Dig It? – StmtCursor and StmtReceive Elements

Can You Dig It? – StmtCond Element

Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt A couple posts ago in the plan cache series I discussed the children for the Statements element.  This next post will focus on the second of the five possible child … Continue reading Can You Dig It? – StmtCond Element

Can You Dig It? – StmtUseDb Element

Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt The last post in the plan cache series discussed the children for the Statements element.  As I noted in that post, there are five possible children.  This post will focus … Continue reading Can You Dig It? – StmtUseDb Element

Can You Dig It? – SHOWPLAN XML Structure

Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt In the last couple plan cache posts, I talked about a couple items that are available within the SHOWPLAN XML for an execution plan.  These posts looked at how to … Continue reading Can You Dig It? – SHOWPLAN XML Structure

Can You Dig It? – Missing Indexes

Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt When I started using XQuery to dig into the plan cache, it was just searching for some parallelism and I really wasn’t aware that I was using XQuery.  I just … Continue reading Can You Dig It? – Missing Indexes

Can You Dig It? – Parallelism in the Plan Cache

Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt In the lead in to this post, I talked about how the plan cache can be a gold mine of information.  There are a number of places that one can … Continue reading Can You Dig It? – Parallelism in the Plan Cache