Be careful of disabling lock escalations. May not help your system.

If these are locks with different WHERE clauses, are they updating large numbers of rows? Or single rows?

Usually locks will...

Can you give an idea of what's fast and what's slow in terms of time? If you make 3 direct calls it should be fairly close in time to all...

Are there not headers in your test files on your workstation?

Headers cause problems in DTS. If there's a way to remove them, I'd do that.

Or load the entire file into...

Your best bet is to follow the advice from Karl and restore to another database and copy the data back. I've done that often, even had to this year

First, please don't use so much whitespace in posts.

second, what you want is a cross tab. If this is for a report, it's much better to do this in the...

Wow, that is interesting and thanks for the update.

Wow, not sure why you guys want to mess with the system tables. The design dates back to 98 with SQL Server 7 in the beta 3 design and has...

The notes above make sense and I'm not sure why you'd run clear cache.

SQL Server executes its own CHECKPOINT internally every 1-5 minutes. It doesn't make sense to regularly...

It would be the master, but that could cause you issues.

You only need to fix this once, so I'd do this one of two ways. You can run sp_Change_users_login...

, not us non-BI people.

I'll have to send this to a few of the BI crowd. Very nice.

I'm not sure there's a size limit, but with a file that size you might have issues if there's any network hiccup. Your best bet might be to send it...

Microsoft has been a little sloppy with SP2. I wonder if they put too much of a testing burden on Beta and CTP testing and getting feedback.

I got this from...

I agree with that. I can't believe that these companies get the benefit for the millions they spend. Personally I'm a Yankee Stadium, Texas Statium, The Forum in Englewood, Candlestick,...

Actually it's Andy's fault! He wanted these forums and coded to them

I was happy with plain ol' ASP. Much simpler.

Hopefully this will be...

I agree with the above. Looks like .NET problems.