Search
Blog Series
-
Popular Posts
-
Recent Posts
- “Thou Shall Not Shrink the Database” #TSQL2sDay
- May 2012 – Monthly SQL Server Checklist
- Can You Dig It? – Determining Index Plan Usage
- Changing Priorities
- SQLFriends in Minneapolis
- April 2012 – Monthly SQL Server Checklist
- SQLCLR: Good? Or Evil? #MemeMonday
- April #Meme15 Assignment
- Re-blog – March 23 – March 29
- Re-blog – March 16 – March 22
-
Tag Archives: Plan Cache
Can You Dig It? – Determining Index Plan Usage
A while back I was asked, if you can use the plan cache to determine which plans are using specific indexes. The answer is, of course, yes, you can. And it’s important that people, especially DBAs, understand how to do … Continue reading
Can You Dig It? – Researching Index Scans
Follow the rest of this series at the Can You Dig It? – Plan Cache series introduction post. It’s been a while since the last plan cache series post. In the last few posts, I was focusing on specific attributes. … Continue reading
Can You Dig It? – Plan Cache Series
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. … Continue reading
Can You Dig It? – Find Estimated Cost
Follow the rest of this series at the Can You Dig It? – Plan Cache series introduction post. She can dig it! D Sharon Pruitt It’s the eighth post in the plan cache series. I hadn’t expect to take as … Continue reading
Can You Dig It? – Find Estimated RowCounts
Follow the rest of this series at the Can You Dig It? – Plan Cache series introduction post. She can dig it! D Sharon Pruitt It’s the eighth post in the plan cache series. I took a few days off … Continue reading
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, … Continue reading
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 … Continue reading
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 … Continue reading
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. … Continue reading
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 … Continue reading
