May 10, 2011 at 8:10 am
Ninja's_RGR'us (5/10/2011)
You think 40 seconds to run this is slow??? Granted it's not blazing but certainly not slow.That one is out of my expertise zone. Letting the other ones shime in.
How long to just run the select (can test with select COUNT(*) FROM (big select)).
May 10, 2011 at 8:11 am
Though it's for big recordset but columns are few (6-8). So i think somehow it should be more efficient. But how, donno. Please let me know if anything can be done.
May 10, 2011 at 8:12 am
sqlnaive (5/10/2011)
Though it's for big recordset but columns are few (6-8). So i think somehow it should be more efficient. But how, donno. Please let me know if anything can be done.
Just in case you missed my 2nd post, how long to just run the select (without the insert).
May 10, 2011 at 8:21 am
That doesn't seem to be a valid query plan - it won't open in Plan Explorer. It also goes WAY beyond simple help that you get for free on a forum. I STRONGLY recommend you get a performance tuning professional on board for a few hours to help you out with that. There are numerous on this forum you could use if you don't know someone already.
One last free thing I will give is to look to eliminate the CONVERT_IMPLICIT actions in the query. There are other things too.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 11, 2011 at 11:31 am
Thanks SQL Guru for the CONVERT IMPLICIT hint. Rest I'll check on how we can cut down the time. Though this forum I found is of great knowledge fest. It's always great to do some sorts of testing and going into different layers of it. Will try to figure out more on this and keep posted. 🙂
Viewing 5 posts - 31 through 34 (of 34 total)
You must be logged in to reply to this topic. Login to reply