Information

I haven’t had a rant post in a while. There is a saying: “Anything before the word ‘but’ is ignored”. I love Extended Events, but … reading the extended event file is so much pain.

In SQL Server, using the KILL command to terminate a session results in an entry being logged in the error log.
This raises the question: Does the ALTER INDEX REBUILD command with the WAIT_AT_LOW_PRIORITY option also log its actions in the error log?

Read a cautionary tale on how I’ve deceived the SSMS, then promptly forgot about it and, in turn, ultimately confused myself.

The SQL Server 2022 CTP has dropped, and I took a look at the new Extended Events that are available.