|
|
Posted by Erland Sommarskog on 06/07/07 07:27
Piero 'Giops' Giorgi (giorgi.piero@gmail.com) writes:
> 1) Normalizing the data in a common format (Naturally, no two counties
> have the same record format)
But this is a problem you have no matter the solution to load the data,
right? Since you work with a partitioned table, you have the same schemas
for all counties. Once you have normalised the format, you can load it
into a staging table and work from there.
> 2) Updating the db in an "Online" state for Orange County only (With
> more than 3mil rows) checking for "Pre-Existing" records would just
> kill the server, and there are 3077 counties...
Did you actually try it? With proper indexing this does not have to be
that painful.
Then again, if you have code to normalise the data for 3077 counties, I
guess 50 tables with a total of 3077 partitions is a smaller headache.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|