SQL SERVER – Find Largest Supported DML Operation – Question to You
- by pinaldave
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