SQL Server According to Bob

JUNE 6, 2016

As indicated, SQL Server 2016 added the use of SSE and AVX instructions in various code paths to improve performance. This post will outline SQL Server’s decisions around SSE/AVX or software algorithm use. This post will outline SQL Server’s decisions around SSE/AVX or software algorithm use. My recent posts.

Servers 40

Servers Hardware Software Engineering Software 40

SQL Server According to Bob

JUNE 3, 2016

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. Ryan Stonecipher – Principle SQL Server Software Engineer. SQL Server 2016.

Hardware 40

Hardware Cache Servers Software Engineering 40

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. Try SQL Server 2016 Today. In the Sep 2014 the SQL Server CSS and Development teams performed a deep dive focused on scalability and performance when running on current and new hardware configurations.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

SQL Server According to Bob

DECEMBER 18, 2018

Linux may need similar utilities to control various hardware cache installations. You should always validate the Fua capabilities with your device and hardware vendor. To accommodate a wide range of installations and hardware required four (4) options across SQL Server and the HE. Fua = Forced Unit Access. Device Flush.

Servers 90

Servers Media Cache Storage 90