• I'm not entirely sure what you are asking, however in general if you are doing performance tuning like that you can take the Profiler results and store them into a table then sort by duration. Anything that consistently takes too long you need to look at more carefully. A lot of times performance issues are bad joins or missing indexes. Also you could try running the Database Engine Tuning Advisor.

    Kenneth Fisher

    Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]