article thumbnail

SQL 2016 – It Just Runs Faster Announcement

SQL Server According to Bob

My development collogues and I are starting a regular blog series, outlining the vast range of scalability improvements, allowing SQL Server 2016 to run across a wide array of hardware configurations, faster and better than previous releases of SQL Server. ” – Bob Dorr, Principle Engineer SQL Server Support. Follow-up.

article thumbnail

How It Works: SQL Server 2016 SSE/AVX Support

SQL Server According to Bob

This post will outline SQL Server’s decisions around SSE/AVX or software algorithm use. SQL Server asks the CPU if it supports SSE or AVX in order to determine the level of hardware support present on the system. Bob Dorr – Principal Software Engineer SQL Server. Reference APIs such as: CryptDecrypt.

Servers 40
article thumbnail

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

SQL Server According to Bob

Ryan Stonecipher – Principle SQL Server Software Engineer. Bob Dorr – Principal SQL Server Escalation Engineer. Use SQL Server Management Studio (SSMS) or your favorite query editor to connect to a SQL Server 2012 or 2014 instance. SQL Server 2014. DEMO – It Just Runs: DBCC CheckDB. SQL Server.