In a previous post, I discussed running SQLIO against multiple files. The purpose in using multiple files is being able to test not just a single volume's capability to deliver data from storage, but to test the storage as a whole. Doing so is important since, what ever application, in my case SQL Server, is running … Continue reading Staggering SQLIO Sessions Across Multiple Volumes
This past weekend, I took a quick trek into the land of beer and cheese for the second annual Madison SQL Saturday event. The event was a great success, but can you expect less when one of the organizers is wielding a light saber. For a change this time, instead of bringing Sarah Strate (Blog | … Continue reading Presentation Materials “Discovering the Plan Cache” #SQLSat206
After this month's Index Analysis update, I was contacted by a reader about the index analysis script. Reader Dick Baker let me know that he found and had a fix for an issue with the missing_index_impact column. Thanks to Dick for this fix. If you find issues or have suggestions for changes to the script, please … Continue reading A Second March ‘Index Analysis’ Update
In yesterdays duplicate index blog post, I mentioned that there would be an update to the index analysis stored procedure today. Without further ado, you can jump to the bottom and download it. There are a few things I've fixed from comments from people using the script and then major change is the addition of … Continue reading Index Analysis March Update
As I've worked with clients on performance tuning through index improvements, one of the common areas that I discuss with them are duplicate indexes. The problem with duplicate indexes is that they are pointless and redundant. All they provide is an additional physical copy of the index and all you get is another index for … Continue reading That’s Actually A Duplicate Index
Functions might seem to be the answer to all of your desires to consolidate code, and at times they could be. But if you don't know enough about them, they may turn out to be the source of all of your problems and opening the door to architecture choke full of disaster. This week, I'll … Continue reading Webcast “Performance Impacts of User Defined Functions” This Week with Pragmatic Works
Ever have your SQL Server slow down for reasons that you can't explain? Or did you spend all night tuning a query to perfection only to have it bog down in production? Want to find out what's going on? If so, read on... This week, I'll be presenting my session "What Are You Waiting For … Continue reading Webcast “Value of Performing Wait Analysis” This Week with Pragmatic Works
This month, Wayne Sheffield (Blog | @DBAWayne) is running T-SQL Tuesday on PowerShell. T-SQL Tuesday is a monthly blogging event where a number of us in the SQL Server community gets together to blog on a central topic. The topic that was chosen for this month was PowerShell. And more specifically: "Blog about using PowerShell for doing, … Continue reading T-SQL Tuesday – Powershell and Perfmon Results – #TSQL2sDay
Earlier this year, I finally passed the Microsoft Certified Master (MCM) for SQL Server 2008 certification. In the process of preparing for the MCM lab portion, I did a lot of studying. One of the my key resources, were the MCM Readiness Videos that SQLSkills put together a couple years back. The thing is, even if … Continue reading 5 MCM Readiness Indexing Videos You Should Watch
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 … Continue reading STATS_DATE() Doesn’t Indicate The Validity of Statistics
Strate SQL 