SQLServerCentral Best Practices Clinic: Part 1
We exposed the SQLServerCentral cluster for monitoring with SQL Monitor. Just like other companies, we have constraints on resources, and we have more work that needs to be done. Help us configure SQLServerCentral’s database servers with your suggestions on what is the highest priority for a website database back end.
Free ebook: Troubleshooting SQL Server: A Guide for the Accidental DBA
Merry Christmas from SQLServerCentral. We spend much of our working life helping solve SQL Server-related performance problems, hands-on, during consulting, or on online forums. We've seen a few weird-and-wonderful issues but, mainly, it’s the same problems and misconceptions time-and-again. This is our attempt to describe, diagnose, and solve the most common problems with SQL Server 2005, 2008, and 2008 R2. And it's free.
Can a Table Really Have a Clustered Index?
A table doesn't so much "have" a clustered index as a table "is" a clustered index.
DBAs Take Sixth Place
The hot jobs for 2013 are compiles and a number of tech jobs make the top 100. DBAs come in 6th and Steve Jones thinks that's good news for data professionals.
It's the Bits
A woman sues Best Buy for $54million. That's absurd, but her laptop is worth more than the hardware. This editorial was originally published on Mar 3, 2008. It is being re-run as Steve is traveling.
Making the Case for a SQL Server Platform Refresh
With the release of Windows Server 2012, SQL Server 2012, and the new generation of Sandy Bridge Xeon processors, your organization is likely to get many tangible benefits from upgrading your current database infrastructure with a complete platform refresh.
Rudolph The Red-Nosed Tester and Other Festive Arrangements
A Christmas poem and a contest from Simple Talk.
Some tips for working with big data models
The main goal of this article is to present some tips to help professionals that need to work with complex, big, and hard to understand database models that anyone may came across some day.
The Load Poll
This Friday Steve Jones asks what the load on your systems are. Do you know what it is and how it compares to other systems?
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers