Why is Your SQL Server Slow? Here's a Hint

I was talking recently with my friends and former colleagues at Idera about the things that slow down SQL Server. Specifically, the discussion was about things that people could change without a lot of trouble to make their SQL Server run faster. I like to use the phrase “quick performance wins” for these easy-to-fix issues that can generate a considerable performance boost. This conversation led to a whitepaper on 5 things that are making your SQL Servers slow. Watch Idera’s
read more

Performance Tuning Pre-con and More at SQLSaturday 277 RVA

Join me for 2 days of fun and education at SQL Saturday #277 in Richmond, VA on March 21 and 22, 2014. I will be delivering an all-day pre-con session, Performance Tuning and Troubleshooting Like a Pro, on Friday, March 21. The session is only $99 if you sign up before February 20. On February 20th, the price goes up to $125. Title: Performance Tuning and Troubleshooting Like a Pro Level: All levels Description: Do you wish you could turbo
read more

T-SQL Tuesday #49: Wait For It Roundup

A huge round of applause and my thanks to all of the participants and spectators for this month’s edition of T-SQL Tuesday. I hope I didn’t keep you waiting too long for the roundup. <rimshot> Let’s take a look at this month’s participating blog posts: Fellow Certified Master (MCM) Rob Farley (blog|@rob_farley) led off with Waiting, waiting…. Rob talks about what causes SQL Server (and computers in general) to be slow and how to baseline SQL Server waits to detect
read more

T-SQL Tuesday #49: My Go-To Query For Waiting Tasks

I’m not just hosting T-SQL Tuesday, I’m a customer as well. Err, I mean participant. Topic for this month’s T-SQL Tuesday, hosted by yours truly, is … wait for it … Waits and Queues. For my donation to this little blog party, I’m contributing my favorite go-to query for waiting tasks. Do you ever get complaints that SQL Server is “slow”? Yeah, that’s a helpful report, right? when I get those kinds of reports, I like to take a quick
read more

Introduction to Integrity: Data Purity Errors

The final day of this six part series, Introduction to Integrity, sponsored by Idera and their new free tool SQL Integrity Checkhas finally reached its conclusion. Today is the final post and the final integrity issue that I am going to talk about: Data Purity Errors. Data purity issues are when the value stored in a column is out of range for the data type. This is a rare error for databases created in SQL Server 2005 or newer. The
read more

Introduction to Integrity: Chain Linkage Problems

We’re approaching the end of our six part series Introduction to Integrity, sponsored by Idera with our last two postings this week. One of the last two integrity issues, and the one I’ll cover today is chain linkage problems. Chain linkage problems are metadata corruption issues. It is possible in certain situations for the links from one page to another to get corrupted. All pages in an object or index have pointers to the previous and next pages in the
read more

New Whitepaper: 5 Most Common Critical SQL Integrity Issues

Have you been putting off running integrity checks on your databases? Are you unsire where to start or what to do? Stop hesitating and get started right now. If you are new to database integrity and corruption, we have a helping hand to get you started. A new whitepaper on the 5 Most Common Critical SQL Integrity Issues that DBAs will face in their career will get you started. A crucial part of managing SQL Server is performing regular integrity
read more

Introduction to Integrity: Corruption in Nonclustered Indexes

It’s day four of our six part series Introduction to Integrity, sponsored by Idera, and tonight’s topic is going to be an easy one. You won’t even need good backups to deal with this one. After you have dealt with several incidents of corruption, you will find yourself hoping for an index ID greater than 1 when you encounter corruption. Corruption in nonclustered indexes is the easiest form of corruption to fix as long as the underlying heap or clustered
read more

Introduction to Integrity: Corruption in Clustered Indexes and Heaps

For day three of this six part series Introduction to Integrity, sponsored by Idera, we will take a look at my number two integrity issue: corruption in clustered indexes or heaps. Unlike corruption in allocation pages, we have several options for dealing with this type of corruption. This particular corruption issue does require a lot more care than many of the others types we will look at in this series. If the corruption occurs in index ID of 0 or
read more

Introduction to Integrity: Corruption in Allocation Pages

Welcome back for day two of this six part series Introduction to Integrity, sponsored by Idera. In this post, I want to dig into the first integrity issue, corruption in allocation pages. If you run the DBCC CHECKDB command and get errors, I isolate the most important errors (Level 16) and look at the page IDs in the errors. one of the first things I want to know is what type of page is corrupted. As I said in day
read more