Re: Execution Plan Hinting

Ryan,

another possible workaround might be to :

bulk insert into a staging table

BEGIN TRANSACTION
DELETE * FROM Whatever
INSERT INTO Whatever... select ... from staging table
COMMIT TRANSACTION

.

Relevant Pages

  • Re: SQL Server 2000: Identity columns guaranteed sequential?
    ... Let's say you have an input file or staging table like so: ... as separate members, but have only one address and then link them. ... SQL Server MVP ... INSERT transaction A is assigned 301 ...
    (microsoft.public.sqlserver.server)
  • Re: Ignore SqlBulkCopy errors
    ... batch either committed or not. ... you need to use the bulk insert statement nested in a transaction. ... errors on duplicate key, I want ...
    (microsoft.public.dotnet.framework.aspnet)
  • Execution Plan Hinting
    ... BEGIN TRANSACTION ... The first is a deletion of the data and the second is the bulk insert ... Will this give sufficient hint to SQL about the order it processes it ... I've seen that some hints can be passed to SQL for optimizing, ...
    (comp.databases.ms-sqlserver)
  • Re: Bulk Insert
    ... in memory much like a file format and bulk inserted from that point ... > seconds if the inserts are part of the same transaction and you are using ... > You could build a single string of insert statements (or proc executes) and ...
    (microsoft.public.sqlserver.programming)
  • Re: CDatabase Transactions
    ... I'm doing bulk loading using the ODBC bulk opns ... transaction using BeginTransand CommitTrans, ... I was just wondering if there's something peculiar about MFC CDatabase ...
    (microsoft.public.dotnet.languages.vc)