That should work on 2005 and above as best I know. Not sure about 2000. Also, I noticed in the trace, some of the queries look a bit sequential, based on the parameters. Maybe like you are looping over a result set and doing queries for each record in that first result set. If so, that could be a huge improvement point.
Byron Mann Lead Engineer & Architect HostMySite.com On Thu, Jun 13, 2013 at 1:49 PM, Paul Vernon < paul.ver...@web-architect.co.uk> wrote: > > Hi Byron, > > > Here's a simple one to show you real time what is executing on the > > server. > > What version of SQL Server is that for? > > Paul > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355930 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
