SQL2008의 새로운 기능 - TF-610 (최소 로그)

http://www.sqler.com/137190#0


INSERT SELECT :

non-FULL recovery model
AND not replicated
AND (
  (Heap AND TABLOCK)
  OR (B-tree AND empty AND TABLOCK)
  OR (B-tree AND empty AND TF-610)
  OR (B-tree AND nonempty AND TF-610 AND new key-range)
)

With this trace flag on, insertions into a B-tree
don’t have to use the TABLOCK hint to benefit from
minimal logging. Also, insertions into nonempty
B-trees can be done in minimally logged mode—at
least partially.

1) TF-610 옵션 설정 방법
DBCC TRACEON(610, -1);

2) non-FULL recovery Model
SIMPLE recovery model, Bulk_LOGGED

3) B-tree 의미
clustered or nonclustered index