Hello,
My company is doing an upgrade from 2000 to 2005 and we are taking the oppurtunity to cleanup some of the report queries. One I did today went from 10 minutes to 1:30 fresh and then 2 seconds once SQL has the execution plans. Anyway, what I was looking at the execution plan trying to find more places to cleanup and I noticed a few implicit conversion that I didn't notice. Be nice to be able to have a tool that could tell me what is being implicitly converted withouth hovering over the execution plan. Other tweaking tips would be appreciated from the tool as well.
Be uber cool if it could tell when indexing my temp tables would be worth the cost. Thanks.