create a computed column for substring(Entrprisename 13,9), and index it...should help speed things up.

Just for giggles - which server did you fire off the transfer from?

Meaning - was it a pull or a push? (A pull is often MUCH faster)

Did you drop the...

You're welcome@!

Make sure none of the other services start up and "steal" your connection. SQL Agent, SSRS, Analysis Services, leave them off.

Try something like:

Select * from information_schema.views

That's the 2005 version.

in 2000 - should be more something like:

select so.name,

sc.text

from syscomments sc inner join...

A few comments:

- trying to make this generic is going to force you to use a stored proc and not a function. You essentially can't do dynamic queries...

Are you shrinking the logs after you back them up? If so - they're going to keep growing.

For what it's worth - stable or no, happy or no, I wouldn't go around advertising who I work for. Especially if you don't have something else lined up....

So - what happens? All your instead of trigger seems to do is to make sure two fields are populated. Do you get rows inserted? No rows?

Your load will go a little faster if you can drop the non-clustered indexes before the truncate, and add them back in after the new data is loaded in. ...

YSLGuru (9/22/2008)

---

1) Are there some features or T-SQL syntax that could be used on/against the DB on SQL 2000 that can't be now that it is on SQL 2005 even...

Jack Corbett (9/22/2008)

---

Yeah Matt, I thought that as well, but also thought the OP may not have posted all the logic needed so I tried to give an idea of...

Hmm - missed that one. Thanks for the link; I will check out.

Timothy (9/22/2008)

---

Unless I'm missing...

Adam Machanic (9/22/2008)

---

I'm not sure which extra overhead you're referring to; LINQ to SQL shouldn't have much if the solution is properly defined and if you make proper use of...