Oh yes, the old brain transplant trick. Haven't had to do that in years. I'll give that a try. The thing is, the most useful stuff I...

The chance of that is zero. There is the 20 foot cable option, whereby a given server can be attached to the old domain controller and (a reboot or...

My past experience has been that adding rows to a large table takes a fraction of a second. I've always found this strange, and can't reasonable explain it.

I'd recommend...

When working on deleting audit data from several very large tables without indexes, I borrowed a trick from warehousing: I created appropriate indexes, ran the deletes, then dropped the indexes....

Some background: I'm reviewing the (admittedly nonexistant) index rebuilding routines on our main Production database (a bit under 10G). I've identified some "worst performing" indexes (primary key, clustered, identity...

It is wrong. Text, ntext, and image columns can appear anywhere within the list of columns.

Philip

A possible problem with Mark's MSDE solution:

 - They own the server MSDE is running on

 - They stop the service

 - They copy the database files to another server

 - The attach it...

A quick comment on the domain vs. local groups issue: Way back when, the SysAdmins told me that you'd want to use the global-to-local group methodology in Windows NT 4.0,...

Turned out to be a combo of weird and stupid.

I'd worked out the code and format file (247 columns into 21 with unlikely column and row terminators). All values were within...

Disclaimer: I am not an economist, nor do I play one on TV.  But I did hear a fascinating discourse on NPR once, which I'll attempt to summarize below. This...

Still fumbling at straws here--I've no facts or evidence to back this up, it's just something that might be worth looking into.

When your doing the bulk inserts, are there indexes...

I haven't done much bulk data loading, and I'm probably way off base here, but it sounds more like a connectivity issue than a hardware one. Leastways, given the setup you've...

It all depends on how they ran their survey--who they asked (and of them who actually responded), what questions were asked, how the resulting data is glommed together... all tricky...

By the way, I just realized my method is utter crap. Anyone could put anything they wanted into the file called by OSQL (DROP TABLE CLIENT, anyone?) and you'd have...

From a practical point of view, everyone who's posted so far is correct. Write and submit a CYA letter, let people know you are not happy with the situation... and...