Remove 2016 Remove Software Engineering Remove Storage Remove Testing
article thumbnail

All of Netflix’s HDR video streaming is now dynamically optimized

The Netflix TechBlog

HDR was launched at Netflix in 2016 and the number of titles available in HDR has been growing ever since. A vital aspect of such development is subjective testing with HDR encodes in order to generate training data. The pandemic, however, posed unique challenges in conducting a conventional in-lab subjective test with HDR encodes.

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. CREATE TABLE dbo. ( SELECT.

Servers 63
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better

SQL Server According to Bob

SQL Server 2016 changes the internal design to (CheckScanner), applying no lock semantics and a design similar to those used with In-Memory Optimized (Hekaton) objects, allowing DBCC operations to scale far better than previous releases. The following chart shows the same 1TB database testing. SQL Server 2016. or newer release.

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. Testing shows that by using the Fua bit with the data, write request can reduce the I/O traffic by ~50% for a SQL Server, write-intensive workload. Starting with the Linux 4.18 Starting with the Linux 4.18 4 Socket, TPCC.

Servers 90