I'm used to working with SQL Server databases that are somewhat small (10 GB or less, usually a lot less), so I'm curious how people deal with huge databases, like those that hold Amazon's transactions or whatever. Do you have to have the latest and greatest hardware running with clustered servers? Do you have to do a lot of database partitioning? How do you handle upgrades? Do you do then in the middle of the night so that you can take the db down briefly?
Wikipedia currently has two different dates for Max Roach's death within the same article. Hopefully it wasn't a prolonged death... is there disagreement about the actual time a person becomes dead, as there is about the actual time a person becomes living?
I think I may have found an undocumented difference between SQL Server 2000 and SQL Server 2005. When you attempt to add a non-null column without a default to an empty table in SQL Server 2000, for some stupid reason it won't let you if you use ALTER TABLE ADD [column]. You are forced to drop and recreate the table with the new column added to the CREATE TABLE statement. This appears to be different than SQL Server 2005, which wisely does allow such a command to execute without error. I haven't ......