Geeks With Blogs

The Wrecking Bawl Destructuring query language, one keyword at a time. August 2007 Entries
how do you handle huge databases?
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?

Posted On Wednesday, August 22, 2007 4:55 AM

so long Max
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?

Posted On Thursday, August 16, 2007 9:31 AM

ALTER TABLE difference in SQL 2005
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 ......

Posted On Tuesday, August 7, 2007 5:23 AM

Copyright © Alex Bransky | Powered by: