I am giving a talk tomorrow (Tuesday) night at the Austin PASS group on how Update Queries are processed/optimized in SQL Server.  The talk will be at the Microsoft office in Austin (which recently moved). More details can be found at the CACTUS...

In my previous post, I debugged a customer problem for you, including the various guesses I had to make and why they matter. The specific problem was likely related to parameter sensitivity, an issue in query optimization where the optimizer will try...

(well, one case of it – the topic is too large for a blog post, so I will focus) I will paraphrase a question I received over the weekend from a SQL Server user: “My server is doing fine.  all of a sudden CPU use goes to 100% and stays there. ...