What Do the LCK_M_SCH_M and LCK_M_IS Wait Types Indicate?
You’re investigating your SQL Server’s top wait stats, and you’re noticing a lot of LCK% waits. Normally, that […]
Locking, Blocking, and Isolation Levels
Meme Week: NOLOCK? NOSQL.
When you find yourself using NOLOCK, consider NOSQL instead. NOLOCK has 4 big problems: Your query can see […]
Meme Week: SET DEADLOCK_PRIORITY HIGH
Hey, this seems harmless. Seriously, don’t SET DEADLOCK_PRIORITY HIGH. Even setting it to low can be a bad […]
NOLOCK Is Bad And You Probably Shouldn’t Use It.
I’m waiting for the YOLOck option. When you put NOLOCK in your query, SQL Server will: Read rows […]