Hi Guys, Thanks for all your advice. It turns out what I thought was the cause of the problem was just a red herring. This query was joining on a few tables and recently one of the tables it was joining on had grown two or three fold causing the result set of the query to grow exponentially. We worked around the join and were able to greatly improve the performance of the query. I'm still unsure why the original query ran quickly in SQL Server Management Studio vs. From Coldfusion but I think that is a harder question to answer.
Regards, Asaf ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328078 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
