Paul White NZ (3/31/2010)
CirquedeSQLeil (3/31/2010)
Adam Machanic summarizes his testing here.In the comments, Adam notes that there seems to be no difference in SQL Server 2008...
My testing shows that any application of the two in which I would use them would be negligible in SQL2k5 and 2000.
I guess the end result being - it depends.
And since 2008 is where people should be moving - mute point?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events