The Top 5 Most Common Problems With SQL Server

Top 5 Most Common Problems With SQL Server

Over the years I’ve been able to compile a list of issues that I would consider to be common with SQL Server (and other database platforms like Oracle, no platform is immune to such issues). These are the issues that are often avoidable but not always easy to fix once they have become a problem. The trick for senior administrators such as myself is to help teams understand the costs, benefits, and risks of their application design options so as to avoid these common problems. So, here is my list of the top 5 most common problems with SQL Server.

You’re Doing it Wrong: 5 Factors That Affect Database Performance

You’re doing it wrong. You didn’t mean to be that way, I know. But the truth is things happen. When they do I am brought in to find out what is happening, what has gone wrong. I see repeating patterns in the database issues I am asked to investigate. I keep track of them as I … Read more

How To Find Duplicate Indexes

I’ve had this script in my toolbox for a few years now. I didn’t create it initially, and I have no idea who did. This script helps you to identify duplicate indexes. Why is that important? I’m glad you asked, mostly because I’m tired of answering my own questions and it’s good to have someone … Read more

SQL University – Indexing Week

Welcome back to this week’s installment for SQL University. The topic this time is all about indexing. I know, I know. It sounds incredibly exciting, right? I mean, what could possibly be more exciting than a comprehensive review of a B-tree? Or a lively discussion about having a heap or a clustered index? Lots of … Read more