I've used both extensively, and have found myself preferring non-GUIDs for the last year or so, simply because of ease of use. It's just plain much easier to deal with...

The key isn't random just because it's an identity, as long as when the records for the date table were created in the correct "month" order. And no, it isn't...

One suggestion for Question askers... try it before you ask. Now, I don't generally knock question contributors because I do not take the time to contribute myself, so I won't....

Full backups every night and log backups every 30 minutes, all of which we keep for eternity. Our production database is pretty small anyway (1 GB), so we're lucky there....

"The UPDATE(Column) function returns TRUE even if an UPDATE does not change the value."

But, the update DOES change the value, right? Even though it may be the same value, it...

Sorry, but the author should probably get a clue as to what Independence Day is really all about. It's amazing how many people just take for granted the freedoms we...

As far as export, you can also use one of last century's commands to get a file copy of your diagram:

bcp MY_DB..sysdiagrams out MY_DIAGRAM.bcp -c -T -S SERVERNAME

Then you can...