That's a good read for you at the moment.

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

itpcpro (5/26/2011)

---

I am currently reading SQL Server 2005 Unleashed from cover to cover to get a full understanding of everything that could happen with the sql server and to see...

Are you sure the error's comming from there? I don't see anything that could produce more than 1 row there.

Top right, click the view report button.

Please post the actual execution plan.

Also have you tried reversing the query to see if it runs faster from the remote server? It might be faster to get the...

itpcpro (5/26/2011)

---

No...

Thanks for the info.

Still works great tho :-P.

What didn't you understand in my previous post?

What part of ONLINE = SOMETHING OTHER THAN OFF GOES HERE are you having troubles with?

estimate vs actual.

Optimization level (early terminaison reason)

ONLINE = didn't ring a bell?

Just a FYI, dta is a bad tool to do performance tuning. This is what I do :

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

I use a binary search to do this...

comment out half the lines and see if the error goes away. Keep commenting half the columns untill you target the problem...

itpcpro (5/26/2011)

---

I have been a SQL DBA for 3 yours now.. I do not have a degree or any certifications (But I am working on getting both).. But I am...

It's not like you have a choice here...

You must put it on a local drive, then copy to network, then delete.

I do this instead of move in case something goes horribly wrong during the move. That...

Then have the tool reinstalled by someone who has the...