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. Instead the design of CMemThread was updated.

Servers 40

Servers Azure Software Engineering Design 40

SQL Server According to Bob

JANUARY 28, 2018

Resource Manager – Database, File System, with ACID capabilities. There is a technique that can be used with SQL Server (Windows, Azure or Linux) to support some DTC capabilities. Note: SQL Server Azure does not support DTC. However, this technique can be used with SQL Server Azure as well. Microsoft MSDTC protocol.

Servers 40

Servers Azure Engineering Java 40

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. For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes.” – [link]. The Back Story.

Servers 90

Servers Media Cache Storage 90