Horizontal Partitioning
Posted in Code Sample, Computers, SQL on July 12th, 2007 1 Comment »
We’ve got a moderately large database here – 80gb, 5 tables and 500m rows – and we had problems updating it. Following a bout of Horizontal Partitioning we’ve now got 130 tables and those rows distributed evenly across them. However when a check constraint was updated today SQL Server 2000 wouldn’t allow data to import [...]