SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. Microsoft SQL Server Database Engine Input/Output Requirements. Device level flushing may have an impact on your I/O caching, read ahead or other behaviors of the storage system.

Servers 90

Servers Media Cache Storage 90

SQL Server According to Bob

JUNE 3, 2016

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

Hardware 40

Hardware Software Engineering Transportation Scalability 40

Abhishek Tiwari

DECEMBER 13, 2017

This is a question recently asked and explored by a team of Google researchers led by Jeff Dean with a major focus on database indexes. More importantly, if this works out well, this could lead to a radical improvement in performance by leveraging hardware trends such as GPUs and TPUs. Learned indexes. Bigger picture.

Artificial Intelligence 40

Artificial Intelligence Hardware Google Benchmarking 40

SQL Server According to Bob

JUNE 3, 2016

The following chart shows the same 1TB database testing. Ryan Stonecipher – Principle SQL Server Software Engineer. Bob Dorr – Principal SQL Server Escalation Engineer. On the same hardware/machine repeat steps 1 thru 3 using an instance of SQL Server 2016 CTP 3.0 MultiObjectScanner = Older design.

Hardware 40

Hardware Cache Servers Software Engineering 40