The default value of the Maximum insert commit size is 2147483647, the largest value a 4 byte INT will hold. This value is default set in SQL 2012+ but you need to set it manually in versions lower then 2012. In most cases you will leave this setting alone. The value of 0 indicates that all …
Read More »