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

Servers 63

Servers Database Testing Efficiency 63

The Netflix TechBlog

NOVEMBER 29, 2023

HDR was launched at Netflix in 2016 and the number of titles available in HDR has been growing ever since. Bitrate versus quality comparison HDR-VMAF is designed to be format-agnostic — it measures the perceptual quality of HDR video signal regardless of its container format, for example, Dolby Vision or HDR10. The graphic below (Fig.

Open Source 252

Open Source Software Engineering Internet Internet 252

SQL Server According to Bob

JUNE 22, 2016

Prior to SQL Server 2016 the trace flag –T8048 is used to upgrade (only) NUMA partitioned, CMemThread objects to CPU partitioned based objects. Keep in mind that the vast majority of CMemThread objects (SQL 2005, 2008, 2008 R2, 2012, 2014, Azure DB and 2016) are not partitioned. Trace flag –T8048 longer exists in SQL Server 2016.

Servers 40

Servers Azure Software Engineering Design 40

SQL Server According to Bob

JUNE 3, 2016

Internally DBCC CHECK* uses a page scanning coordinator design (MultiObjectScanner.) 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.

Hardware 40

Hardware Cache Servers Software Engineering 40

Rigor

SEPTEMBER 11, 2019

Rick is a software engineer on the Google Chrome team, “leading an effort to make the web just work for developers.” Follow him on Twitter @ RickByers and be sure to watch the video of his conversation at Chrome Dev Summit 2016 , where he discussed the ways Chrome is “improving predictability for developers.”

Performance 89

Performance Education Google Website 89

SQL Server According to Bob

NOVEMBER 8, 2016

SQL Server 2016 Service Pack 1 (all SKUs) , in combination with Windows Server 2016 (All SKUs) or Windows 10 Client introduces non-volatile memory support for the tail of the log file (LDF) which can significantly increase transaction throughput. SQL Server 2016 is designed to detect non-volatile storage devices.

Cache 40

Cache Servers Media Storage 40

SQL Server According to Bob

JUNE 27, 2016

That is exactly what I started doing in Mar 2016. I have 20+ years of support experience that I am able to bring directly to the designs and implementations. For example, we were designing how to capture a crash dump. Last week I meet with Aditya and went over 4 pages of SQL Server gotcha’s that he could apply to his design.

Servers 40

Servers Games Azure Software Engineering 40