If you don't have two records in there, rather it would be a union of two queries.

If you ahve

TableFriends

OriginalFriend Friend Approved

Steve ...

Are you querying over 200 tables? That's a problem in itself.

I'll say this. I've taken the 441, 443, and 444 exams. In the case of 441 I went in pretty cold and passed. I've done a little work with ss2k5,...

My wife says she's used Netmeeting and it's slow. She recommends http://www.box.net for quick file transfers.

Frank,

I agree that if someone doesn't do the same job at the same level, then there should be a reason for pay differences. Figuring out "sameness" is tough anyway and...

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.