SICS 20.2
SE-1861 #
Adding a new column to an existing table when a default value needs to be set results in SQL to update the entire table. For a table with a large number of rows, this causes a large transaction log in Microsoft SQL Server.
To prevent this, large table updates on Microsoft SQL Server will be batched into increments of 10k rows when the Optimized Schema is in use.