New Metadata-Only Column Changes in SQL Server 2016
SQL Performance
APRIL 17, 2020
Improvements in SQL Server 2016. The subject of this post is the additional changes that are enabled for metadata-only from SQL Server 2016 onward. ALTER COLUMN id bigint NOT NULL ; Thanks to the improvements in SQL Server 2016, this command changes metadata only , and completes immediately.
Let's personalize your content