Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

parallel inserts for data analysis (ie very large not many small transactions) Expand / Collapse
Author
Message
Posted Wednesday, March 21, 2012 10:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 6, 2012 1:36 PM
Points: 2, Visits: 37
It is clear that sql 2008 r2 will not automatically parallelize inserts - it will only automatically parallelize the select part of those inserts. Have they improved this in sql 2012 ?

Large Inserts from one table to another are much faster generally when tablock is used. Is there anything better - maybe something that turns of all logging ?

It is possible to manually parallelize inserts of course but then tablock wont work so I found I had to use many parallel inserts to equal the speed of one insert with tablock with a typical query. Partitioning did not seem to speed up parallel inserts. Anybody have better ideas on manual parallelization ?
Post #1270308
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse