When was the new “Safely Auto Size Columns” added and what exactly does it do differently from “Auto Size Columns” ?
EDIT: Ok so I can partly answer this myself, comparing using Auto Size vs Safely Auto Size, for example on the ScreenMenuItems table, I can see some columns are set as nvarchar(MAX) as opposed to setting specific size on every column. I am guessing this is to reduce the amount of “auto resizing” that happens during use? @emre what is the difference regarding performance with safely vs standard auto size columns?
Auto Size Columns
Safely Auto Size Columns
