From time to time, you might have caught yourself in a conversation similar to the following: Fred: Hey folks, we have a query that isn’t working right anymore? Wilma: I wonder if there’s a problem with the statistics. Maybe they are out of date. Barney: I checked the statistics with STATS_DATE() and they are really [...]
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 this. Usually during index analysis, we concern ourselves with whether an index is being used. [...]
At some point last year after finishing the 31 Days of SSIS, I decided to bundle up all of the posts into a single document. That way, if someone was on the go and didn’t have a good internet connection or wanted be able to read all of the posts in a single setting it would [...]
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 [...]
If you are looking for a little training on SQL Server Integration Services (SSIS) without having to leave the comforts of your cubicle – this is your week. This Friday (11/19/2011), SSWUG will be hosting an expo titled “Building and Developing with SQL Server Integration Services”. The event will consist of four sessions that will [...]
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 [...]
Turns out there is a snag when it comes to using Internet Explorer 9 with SharePoint and SQL Server 2008 R2 Reporting Services. If you need to export a report, the export options don’t exists. There’s an open Connect item on this, please take a moment to up-vote this item.
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 [...]
_1262.png)
