SQL SERVER – Find Largest Supported DML Operation – Question to You
Posted
by pinaldave
on SQL Authority
See other posts from SQL Authority
or by pinaldave
Published on Wed, 16 Jun 2010 01:30:35 +0000
Indexed on
2010/06/16
1:33 UTC
Read the original article
Hit count: 883
best practices
|Pinal Dave
|Readers Contribution
|Readers Question
|sql
|SQL Authority
|SQL Query
|SQL Server
|SQL Tips and Tricks
|SQLAuthority News
|SQLServer
|T SQL
|Technology
SQL Server is very big and it is not possible to know everything in SQL Server but we all keep learning. Recently I was going over the best practices of transactions log and I come across following statement.
The log size must be at least twice the size of largest supported DML operation (using uncompressed data volumes).
First of all I totally agree with this statement. However, here is my question – How do we measure the size of the largest supported DML operation?
I welcome all the opinion and suggestions. I will combine the list and will share that with all of you with due credit.
Reference: Pinal Dave (http://blog.SQLAuthority.com)
Filed under: Best Practices, Pinal Dave, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLServer, T SQL, Technology
© SQL Authority or respective owner
