468,104 Members | 1,308 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,104 developers. It's quick & easy.

bulk insert in clustered index table

Hi,

I have got the following situation please give me some ideas how to
solve/work around it.

Current situation: Everyday day about 10 million records are processed
and bulk inserted in individual tables. Around 20K records are
inserted at a time. At the end of the day this table is clustered
indexed. The field used for indexing is not a primary key. There is no
primary key in this table. After indexing read access is given and
user run reports from the frontend using the clustered index field.

Hope to achieve: Table will be clustered indexed from the start and
bulk insert (10 mill records/day) will be done on this indexed table.
At the same time users will have access to this table to run reports.

Now we all know inserting data in a an indexed table (specially
clustered) is a bad idea. So is it completely impossible? I have seen
the same thing being done in Oracle database. Is it possible in SQL
Server.

From this blog: http://www.sqljunkies.com/WebLog/afe.../02/41931.aspx
it seems that if I dummy sort the data before inserting then I can
overcome this performance issue. But then bulk-insert will be useless
here.

Please help.

Thanks in advance.
Jun 27 '08 #1
0 2349

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Chris | last post: by
2 posts views Thread by David Sharp | last post: by
6 posts views Thread by pk | last post: by
2 posts views Thread by kumar | last post: by
16 posts views Thread by Philip Boonzaaier | last post: by
2 posts views Thread by Zarrin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.