February 2010 - Posts

• SSMS tips: Okay, it’s an SSMS trap!

  Boston is not nearby for me to attend Aaron’s presentation on Management Studio Tips & Tricks . But I did enjoy reading his presentation deck, and that reminded me of an SSMS trap I fell into not too long ago. Here I’d like to bring it to your attention Read More... Posted Friday, February 12, 2010 9:52 PM by Linchi Shea | 3 Comments Filed under: SSMS

• Killing a SQL Server thread? Don’t!

  Sometimes, when you kill a session (i.e. a spid) in a SQL Server instance, the spid just refuses to go away not because it’s doing a rollback. Perhaps, it’s stuck on a certain dependency on something external to SQL Server or it’s just simply stuck for Read More... Posted Thursday, February 04, 2010 4:09 PM by Linchi Shea | 11 Comments Filed under: Best Practices, Testing