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
It's the first Monday of the month, do you know where your servers are? Hopefully, they are still in your data center. If not, I'm not sure this post will help you out, so you better just call the police. But if they are in your data center, then do you know how they are … Continue reading March 2013 – Monthly SQL Server Checklist
Here are the presentation materials for today’s Pragmatic Works Training on the T’s session A Functions Is A Function – Comparison of the Performance Impacts of User Defined Functions. A Function by Any Other Name is a Function from Jason Strate Download: [download id="68"] Other resources: http://msdn.microsoft.com/en-us/library/ms189294.aspx http://www.sqlteam.com/article/intro-to-user-defined-functions-updated http://www.amazon.com/Transact-SQL-User-Defined-Functions/dp/1556220790/ref=sr_1_1?ie=UTF8&s=books&qid=1268026139&sr=8-1
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
Wouldn't it be nice if you had a chance to try out the features of SQL Server? Maybe give them a run-through before your managers asks you to make recommendations on whether to upgrade and what the value in doing so will be. For those of us that don't have the time to build out … Continue reading Five Virtual Labs for the SQL Server 2012 DBA
Here are the presentation materials for today's Pragmatic Works Training on the T's session What Are You Waiting For – Explanation of the Value of Performing Wait Analysis. The other session that I mention during the presentation is Extended Events: Work Smarter, Not Harder. http://www.slideshare.net/JasonSStrate/slideshelf Materials: [download id="67"] If you have any questions from the session, please … Continue reading Presentation Materials “What Are You Waiting For?”
Have you ever had to calculate bitmasks on the fly? I have and still do. In this post, I'm going to show a simple PowerShell script that can be used to generate bitmask values. But first, let's look at a reason that you may have to use bitmasks. Many of today's servers have a fair number of … Continue reading Calculate Bitmasks In PowerShell
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
Seems so early in the year, but it's already time to start getting ready for this year's PASS Summit. There are two things to think about early on with the summit. First, what are you expecting from the summit? The summit is built based on community input and PASS needs to hear your opinions on what … Continue reading Start Getting Ready for PASS Summit 2013
Not exactly groundbreaking information, but were you aware that you can run SQLIO with multiple files? Until a couple months ago, I hadn't really paid attention to that little fact. And maybe I'm the only person that didn't know, but figured I would share it anyways. How Multiple Files? Using SQLIO with multiple files is … Continue reading Running SQLIO with Multiple Files
Strate SQL 