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)