Minimal logging and MERGE statement

re: Minimal logging and MERGE statement

satish — Wed, 05 Sep 2012 05:51:59 GMT

i have enabled 610 traceflag at session level was that so dangerous? because i am scared

re: Minimal logging and MERGE statement

Darryll Petrancuri — Thu, 23 Sep 2010 15:48:58 GMT

Gents,

How can this be when MERGE doesn't explicitly enforce a SORT order?

Respectfully,

Darryll

re: Minimal logging and MERGE statement

Sunil Agarwal — Tue, 22 Jun 2010 04:49:05 GMT

Bart,

You are correct. We only get minimal logging for INSERTs on the rows that go to newly allocated pages. We will still do full logging for UPDATE/DELETE. Yes, session level setting will be a better choice. I was just demonstrating one example.

thanks

Sunil

re: Minimal logging and MERGE statement

bartduncan — Mon, 07 Jun 2010 16:20:10 GMT

Just to clarify, any updates or deletes that the merge does are still fully logged. (Right?)

>> dbcc traceon (610, -1)

This will enable the trace flag globally (for all connections). Was that your intent? Might be better for the example to use a session-level flag.