What was the number one question from today’s webcast on wait statistics? Where can the slides and sample code be downloaded. To answer this question of the ages, click on the download link below. Thank you to everyone that attended. It’s great to share what I’ve learned and also to find out that people find [...]
Another month and it’s another T-SQL Tuesday. This month we are being hosted by Allen White (Blog | @SQLRunr) and the topic is to Share Your Tricks. One of my favorite things to do in SQL Server is to run queries against the plan cache. Within there, you have the ability to see what SQL [...]
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. Instead of continuing on that vein, I want to cover a use case that fit [...]
Want to take a few minutes out of your day on to learn a bit more about indexes? On Thursday, I’ll be presenting at Quest’s Pain of the Week webcast. The session will be Understanding Your Indexes: Operational Stats. There’s a lot that goes on under the covers of SQL Server with your indexes. But [...]
Tomorrow is time for part two of my presentations this month on Extended Events for the PASS DBA Virtual Chapter. If you missed the first part of this series, you can watch it before hand here. Below are the details on the event and the session description… Extended Events, Work Smarter Not Harder – Part [...]
If you are looking to become more familiar with extended events, take a gander at this month’s DBA Virtual Chapter meeting. I’ll be presenting at both of the meetings for the month. The first meeting will cover the basics and some information on where Extended Events is going. The second will cover some deeper content [...]
It’s that time of the month again… again. Time for T-SQL Tuesday! This month’s event is being hosted by Matt Velic (Blog | @mvelic). The topic that he chose for this month is the APPLY operator. This is a great topic. I like it because, often, when I am presenting I ask the question, “who [...]
It’s that time of the month again. Time for T-SQL Tuesday! This month’s event is being hosted by Jes Schultz Borland (Blog|@grrl_geek). The topic that she chose for this month is aggregates. The Dilemma A few months ago, a client I was working with had a dilemma with one of their search queries. A query [...]
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 [...]
Follow the rest of this series at the Can You Dig It? – Plan Cache series introduction post. It’s the eighth post in the plan cache series. I hadn’t expect to take as many days off from this due to the 31 Days of SSIS, but that one had a stricter time table that I [...]
_1262.png)
