blake colson-405790 (6/17/2011)
Check out Benjamin Nevarez if you're still pursuing this. I had several exchanges with him a while back about how calculations were derived by the optimizer. This knowledge helped me figure out expected execution times. My last exchange if you're interested: http://sqlblog.com/blogs/ben_nevarez/archive/2009/09/11/how-the-query-optimizer-uses-statistics-part-ii.aspxHe ended up writing a book: http://www.amazon.com/Inside-SQL-Server-Query-Optimizer/dp/1906434603/ref=sr_1_11?ie=UTF8&qid=1301970045&sr=8-11
Good luck !
-Blake a.k.a CQLBoy
This thread is about 18 months old.
Benjamin's book is really excellent, and I'm saying that despite being the technical editor on it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning