Do partitions allow multiple bulk loads?
Posted
by ck
on Stack Overflow
See other posts from Stack Overflow
or by ck
Published on 2010-04-07T08:38:58Z
Indexed on
2010/04/07
8:43 UTC
Read the original article
Hit count: 160
sql-server
I have a database that contains data for many "clients". Currently, we insert tens of thousands of rows into multiple tables every so often using .Net SqlBulkCopy
which causes the entire tables to be locked and inaccessible for the duration of the transaction.
As most of our business processes rely upon accessing data for only one client at a time, we would like to be able to load data for one client, while updating data for another client.
To make things more fun, all PKs, FKs and clustered indexes are on GUID columns (I am looking at changing this).
I'm looking at adding the ClientID into all tables, then partitioning on this. Would this give me the functionality I require?
© Stack Overflow or respective owner