The single best way to do this is through waits. What your server is waiting on is where your bottlenecks lie. Here is an excellent article showing how to...

A health check is generally not done very often. A server health check is looking at the server configuration, settings, etc., to determine whether or not they are appropriate for...

With such a tiny table, the engine thought that just locking the entire table would be easier than locking individual rows. Or, possibly, you're updating a significant number of those...

Oh yeah. It's part of my presentation.

Yes, it's insane that it isn't taken more seriously.  People will say that they take it seriously, but then not give the people what they need to...

I just presented a new session on SQL Injection at Techorama in Belgium and before that at SQLDay in Poland. As part of the prep, I did searches on recent...

I started watching a YouTube video on Azure DevOps. I can't have the sound turned up where I am, so I turned on subtitles. This is as far as...

Ha! Yeah, that kind of thing happens to all of us. Random mouse click, sunspots, it happens.

Oh, and here's another video on waits and queries.

Honestly, the best resource is the query performance tuning book in my signature. It's completely focused on what you need.

However, to get started with extended events, start with Microsoft.

Well, then it won't matter. If the data will ALWAYS be less than 50 characters then indexing a VARCHAR(50) or a VARCHAR(500) will be the same. It's completely dependent on...

Killing SPIDs just puts them into rollback, same as  this. I'd be more concerned about what's happening, what has changed, what's new that something that has ran for years without...

Well, the "regardless of who is connected" bit is what you've run into. There was some sort of open transaction and it got rolled back successfully. I'd just suggest changing...

That's an error from taking a database into single user mode. That shouldn't normally be a part of a restore process unless people on your server have too many permissions...

This is a very old school (and old) summary of the rules of normalization, with examples. The core concept is, a column or columns has to define what makes...