What Jeff is trying to say here, is that we may help you there as well. We earn a living at doing that kind of stuff and we may...

Jeff is just that good at tuning :hehe:.

Well that's a 5-10 yo PC over VPN connection, running windows 2003 server and SQL 2005 + VS 2005. The problem is that there's only 512 mB of ram....

P.S. Replace all of the smileys byt a closing parenthesis " ) " when pasting the code.

Here's a script I use to do a similar task, I'm not doing any updates, but the selects are quite easy to follow.

Let me know if you have any questions.

...

Yes there is, can you tell us the do something so we can figure it all out?

In the mean time you can check out sp_msforeachtable and sp_msforeachdb

Very quick example :...

Holly shit... is the only way to describe those results!!!

********************************************************************************

Found, no index

********************************************************************************

===== Far Right =====

--------------CharIndex

SQL Server Execution Times:

CPU time = 24187 ms, elapsed time = 24650...

shmuel (9/12/2008)

---

sorry, she gets paid to make the rules. I get paid to be her loyal servant.

Still, why should an sp_inner call from within sp_outer run slower and have a...

How are you calling the sps?

Are the settings the same on all connections (if they are different)?

Are you qualifying the names?

Are you using the same case for all characters?

Just go from there... don't know how you need to use it, so here it goes :

--Make sure Saturday is the 7th day of the week on your server...

I always love to see that from a boss, don't post the sp code, don't post the DDL, but ya sure post the actual full executions plans... they won't be...

Good points... another questions to check with that varchar(2000) is how much of that is actually used. I've seen description fields as varchar(8000) with never more than 25 characters...

Thanx for all the help... there's so much data on the subject, and no simple answer besides asking them... now I know what I'll be talking about and what to...

Just read this, that is your solution (2nd code snippet)

Yes, screw them. Select the data as multiple rows. Present into a single text object... or use a concatenation on the server to present the data (straight in...