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: 166

Filed under:

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

Related posts about sql-server