Press "Enter" to skip to content

ABORT_AFTER_WAIT on Index Rebuilds and the Error Log

Tom Zika performs an experiment:

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?

Tom does violate Betteridge’s Law of Headlines, but you should read the post regardless.

2 Comments

  1. Tom
    Tom2024-05-21

    I did that on purpose. Thank you for noticing!

    • Kevin Feasel
      Kevin Feasel2024-05-21

      You subverted everybody’s expectations along the way.

Comments are closed.