Hello again. We've talked about a process to help you deal with alerts - so now let's start looking at some specifics, shall we? I'm going to lay these out in no particular order - this one is inspired by a colleague of mine, who asked me a great question: "Why do we care about low disk space?" So,..
How to avoid a rabbit hole while troubleshooting SQL Server performance
Performance analysis can be a tricky landscape at the best of times and looking at the performance of your SQL Server is no different. An initial glance at your recent high CPU usage can often spiral into a lengthy investigation, deviating far from the initial investigation.
In this blog I aim to..
Troubleshooting - stay C.A.L.M.
So, you're supporting a server. It might be yours directly, it might belong to a customer. Doesn't matter. You've got an urgent issue - an alert, a ticket, an end-user reporting a problem - and you need to get moving. Where do you start? Everyone has a method, and if you haven't developed yours..
Troubleshooting memory issues
At Coeo, we have the opportunity to deal with a wide range of problems every day and sometimes they manifest in mysterious ways.
Using "With (nolock)"? Read this
Anyone that's worked with SQL for any length of time will undoubtedly have seen and heard the following
Watching out for SELECT * with UNION ALL
UNION ALL returning incorrect results?I recently came across an interesting behaviour when executing queries that included a UNION ALL statement, the examples below were created using SQL Server 2016 Service Pack 1.
The curious case of the slowly starting cluster
I came across an interesting case today that I thought it was worth doing a quick blog post about. I was working with a customer who was migrating onto their newly built SQL Server 2014 clustered instance. Part of the pre-migration testing was to fail the SQL Server service between the two nodes to..