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

Can You Dig It? – 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 this new series of posts, I plan to investigate the SQL Server plan cache.  We’ll start with a little introduction of the plan cache and move into ways in … Continue reading Can You Dig It? – The Plan Cache