I am trying to perform a big INSERT INTO ... SELECT FROM and I just can’t understand why it isn’t using minimal logging.
My SQL Server version is:
Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)
Mar 29 2009 10:11:52
Copyright (c) 1988-2008 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (VM)
I have tried both the Simple and Bulk Logged recovery models for my database. Nothing seems to make any difference. There are no replication publications or subscriptions on the server.
I have reduced my query down to the simplest thing I can think of. I have tried lots of variations on this query; nothing seems to make any difference. Here’s the query:
View Complete Post