Remove 2016 Remove Analytics Remove Software Engineering Remove Storage
article thumbnail

New Metadata-Only Column Changes in SQL Server 2016

SQL Performance

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. Acknowledgements.

Servers 63
article thumbnail

SQL Server On Linux: Forced Unit Access (Fua) Internals

SQL Server According to Bob

Device level flushing may have an impact on your I/O caching, read ahead or other behaviors of the storage system. Patrick and Purvi doing performance and regression analytics. Neal, Matt, and others from Windows Storage, Windows Azure Storage, Windows Hyper-V, … validating Windows behaviors. · Starting with the Linux 4.18

Servers 90