Paul White NZ (9/9/2010)
Rick-153145 (9/9/2010)
I feel I must point out this great typo though, made me chuckle:"1. Convert the naive nested loops join to an index nested loops join "
I still can't see a typo there, Rick.
I'm missing it too. Maybe it was read as "Knave" instead as "naive"
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