Actually, I think in OODBMS or HDBMS, we'd get worse design. Harder to understand. My point is that RDBMS is the easiest (relative) of the 3. Not sure where column...

yes, clustered index = data. No separation there, so it's the largest size.

I think that if you move from datetime to smalldatetime, you will make the indexes smaller, both NCs...

If that's the case, I'd suggest they keep two sessions on their workstation, one with a higher privilege account. Handle issues administratively. Don't allow Outlook, etc. in the high privilege...

Tx, updated with CU6 for SP3 and CU16 for SP2

I think part of the reason that relational dbs, and not object or hierarchial or column dbs rule is the they have a low barrier to entry and they are...

In line with that, does PASS have a five year plan? Beyond 5 conferences? As Grant and Jack mentioned, it doesn't appear that PASS does much to help chapters or...

You can use "RunAs" and launch SSMS this way to connect with a higher privilege account. We used to do that in the W2K days.

There's nothing like this that I know of. You could probably write something that would spawn them a session with a password, or would change the pwd, email it to...

Database Pork Chops

---------------------

4 large chops, bone-in

cayenne pepper

flour

sharp knife

trebuchet

With the knife, sharpen the end of the bones until they achieve a dangerous point.

Liberally coat the chops with flour, the better to...

Ah, my confusion. I was thinking this was a slow restore. My mistake.

GSquared has the reason it's not recommended.

I have used usp or even sp (no underscore) to prefix things.

I do what GSquared does. Define a var.

I like Bru's idea. Create a job to just send all "new" backups across the pipe on a regular basis. That way you'll be moving files as quick as you...

The problem with SQL and networks is that it doesn't handle any delays well. A file copy will retry and work through small glitches. SQL doesn't because the delays can...

We use Rackspace here and at Red Gate. Has been OK. Can probably get you someone to talk to at Red Gate if you want it.