I still don't get why a multi-table script is such a big deal.

Let's say the field name is "MyField".

You run:

select 'Update dbo.' + name + ' set MyField = 5;'

from...

gcopeland (1/13/2009)

---

Given "my stated opinions"...honestly...Is that the best you can...

Yes, I've tried running traces. It takes a bit to figure out, but it's a good way to load test a database as if real users were present.

Not sure what to suggest you look at next. There's probably something that would be obvious if I were looking at your screen, but I can't think of what...

The_SQL_DBA (1/12/2009)

---

GSquared (1/12/2009)

---

I think your best bet is load into a staging copy of the database, copy the files to the production server, then take the production database offline and...

Moving from either to the other, once you have data in them, is a bit of a pain. Depends on how much data you have and how you've structured...

Using some sample data, I haven't been able to re-create your problem. Here's my test:

create table #T1 (

ID int identity primary key);

create table #T2 (

ID int identity primary key,

T1ID...

Cast/convert to varchar, check the len on that.

SanjayAttray (1/12/2009)

---

No matter if reindex job happens in night. It would not grow that big. I don't think any one would do any dml transaction on " msdb "...

Write a join query that creates one row per period per rule that applies to it, give the query a Where clause, and use "select count(*)" on the query. ...

Use quotes around the file path.

Steve Jones - Editor (1/12/2009)

---

Not that I ever got asked to come, but I wouldn't wear a tie to interview with you, David 😀

course, not sure I could pass The...

Grant Fritchey (1/12/2009)

---

Can post the whole execution plan? Save it as .sqlplan file and zip it up.

On a guess, it's performing an aggregation to satisfy the criteria. It might be...

Because chocolate IS better than vanilla! 🙂

Yeah, choices in cases where it doesn't much matter should be fine. I'd say that kind of thing, like which format to use,...

I'm going to guess that the file you're trying to import has something wrong with it.

I've seen that kind of error in files where the delimiter was used within the...