I agree with Ian. SQL follows the OS clocks, and if they're not updating, that's an issue. If you have machines in other time zones, use a standard clock, like...

I did miss the "not at all", which is bad. You definitely need to test systems, though honestly I'm more concerned about the Windows or application level than the SQL...

Ranges. Determine some range for each server and let it grant IDs within that range.

Or set up a central number distributor. Service Broker would be great, but any distributed query...

AFAIK, this cannot happen with SQL logins. Are you sure they're not using Windows auth?

I'd agree as well, but really caution you to be sure your disks are your disks. I've had other vendors really try to build a couple large arrays and then...

As ALZDBA pointed out, you might not want to change the connection. There shouldn't be "users" in a package, but logins that point to a particular server. If you want...

Blocking is not bad. It's a sign that you have concurrency issues and the server is preventing someone from reading while data is being changed.

I'd use Profiler and really dig...

I could see allowing duplicates in a table for some reason, but you'd still want a PK in case you ever needed to work with a row. Even in a...

Not a lot of T-SQL, or guess if code is correct. There are lots of questions on SSMS, where you have a simulated environment and need to do something like...

Typo, fixed now. The $10-20k they see as a investment (for technology, not people), makes it easy to decide to do. Of course they already believed in having a good...

the Dynamic SQL above is really the only way to do this. the IN statement can't take a bunch of parameters or a comma list by itself.

Be sure when you...

In that case, restore it as master_old or some other name, not as "master" on another instance. You just want the data in the tables, not the functionality.

It's not that specific, but it's a nice summary, Rudy.

I like it too!

Tada

http://www.sqlservercentral.com/forums/messages.aspx?forumid=386

Cross posted from another thread, not necessarily in response to Simon. Though I do think Simon raises great points:

I think I've done a poor job of stating my BI position,...