|
|
Posted by Erland Sommarskog on 06/05/07 22:24
Piero 'Giops' Giorgi (giorgi.piero@gmail.com) writes:
> I know that, but partitioning by county makes the DB a lot easier to
> maintain.
> I have to work that way because I'm dealing with criminal records, and
> they are separated by county with a ton of different files, so for
> many of them I have to clear the table and reload the whole county
> every time I get an update. Easier on partitions... :-)
>
> Table size can be anywhere from 8000 to 3 million records, depending
> on the county.
Deleting 8000 rows is a breeze, but deleting 3 million rows takes
some resources, particularly if the rows are wide. But it still only
a matter of minutes.
> But, before trying, can I have 3077 files in ONE partition, and drop
> all the states stuff?
No, in the topic for CREATE PARTITION FUNCTION, I found that you
cannot have more than 999 boundary values.
--
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]
|