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 … Continue reading T-SQL Tuesday #025 – Share Your Tricks #TSQL2sDay
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 … Continue reading Pain of the Week: Understanding Your Indexes
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 … Continue reading Speaking at PASS DBA Virtual Chapter
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 … Continue reading T-SQL Tuesday #17 – APPLY Knowledge
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 … Continue reading Aggregating With Correlated Sub-Queries #tsql2sday
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 … Continue reading Can You Dig It? – Plan Cache Series
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 … 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 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
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
Finally up to the last post of this series resurgence. Time to update the Index Analysis Custom Report that I developed last year. The previous posts in this complete series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output Analyze Your Indexes Part 2 – Find … Continue reading Return of the Index Analysis Report
Strate SQL 