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 web page. (I don’t know if they have my talk announcement up there yet, but hopefully it will be there soon)
(I believe that I will be giving a longer version of this talk at the national PASS conference in Seattle in November, for those of you not lucky enough to be in Austin :)).
I hope you see you there!