A while back I wrote a post on a procedure I created for the DBADiagnostics database that I talk about from time to time. This procedure allowed users to search the procedure cache to find plans for procedures by database name and object name. This had worked out pretty good until I noticed something the … Continue reading Searching for Plans
Ever come across performance counter log that isn’t in your desired format? This is a situation I’ve been in a number of times. And wouldn’t you know, I usually space off the command line tool that I can use to do this. The gem of a tool that you can use to change performance log … Continue reading Changing A Performance Counter Log Format
SQL Server 2008 R2 eBookAs with previous releases of SQL Server versions, Microsoft has released an "introducing" ebook that covers the new features that are a part of SQL Server 2008 R2. If you aren't up to speed with the upcoming release, this is a great resource to give it a once over and understand … Continue reading Free eBook – Introducing SQL Server 2008 R2
A while back I decided I need to get down to brass tacks and figure out SQL Server CLR. I'd looked at examples and seen some pretty cool stuff being done with it. Unfortuantely, I hadn't taken the time to become acquianted enough to know enough about the unknown. This limited my ability to be able … Continue reading FileSystemHelper SQL Server CLR – Codeplex
I’ve been meaning to join in on the T-SQL Tuesday event for the last couple months and let the time opportunity slip by. This month’s topic is reporting and its seems like a good time to get in on the event. The great thing about reporting is that for the past few months I’ve been … Continue reading TSQL Tuesday #005 – Wait Stat Report – #TSQL2sDay
It was bound to happen, a launch event for the upcoming release of SQL Server 2008 R2. This is a great thing because it means we’ll be able to play with the cool new toys in production soon and start getting our client’s upgraded. I do wonder though if there are talking dolphins in these … Continue reading Discover SQL Server 2008 R2
Every now and then I work with people that just use the default trace templates available within SQL Server Profiler. Using the default traces and you end up being limited to just some performance stats on procedures and batches that have completed. There isn't exactly an issue with doing this, except that there is so … Continue reading There Is Much More to Profiler
After setting up backups on a client’s servers, I started to get the error message below each night at approximately the same time. Sometimes on the same database and other times on other database. The only constant appeared to be the time in which the error occurred. Processed 1 pages for database 'MyDatabase', file 'MyDatabase_log' … Continue reading Interesting Backup Failure
A while ago I had read about the hidden threat of forwarded records. These silent killers are like storm troopers in the bush waiting to get you when you least expect it. And then the other day I saw a T-SQL Tuesday post by Sankar Reddy on (blog – twitter) on determining if your SQL … Continue reading Find Tables with Forwarded Records
A few weeks ago I posted a job that I use to track wait stats in the DBA database that I bring to a number of clients. I had promised to follow-up with a couple or three reports that could be used to monitor the values that were being aggregated in those tables. Before getting … Continue reading Wait Stat Categories
Strate SQL 