Tuesday, January 02, 2007

Massive deletes and updates in SQL Server are ALWAYS logged


SQL Server always writes to the log file for massive delete / update operations, even in simple mode.

http://www.realsqlguy.com/serendipity/index.php?url=archives/14-When-Is-A-Transaction-Log-Not-A-Transaction-Log.html&serendipity[csuccess]=moderate

No comments: