Remove c
article thumbnail

SQL Server on Linux: ELF and PE Images Just Work

SQL Server According to Bob

Last March I moved from 22 years in SQL Server support to the SQL Server development team, working on SQL Server on Linux project and reporting to Slava Oks. As Slava highlights in his recent blog post , he also contacted me in early 2015 to assist with supportability of SQL Server on Linux. There are no burning secrets.

Servers 40
article thumbnail

SQL Server On Linux: Forced Unit Access (Fua) Internals

SQL Server According to Bob

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. The Back Story.

Servers 90
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

How It Works: SQL Server DTC (MSDTC and XA Transactions)

SQL Server According to Bob

Note: SQL Server can be a client using a linked server, allowing SQL Server to become an APP and/or an RM ). The application then uses the SQL Server client (SQL Server ODBC for this example) to establish a TDS based connection to the target SQL Server (local or remote.). Local Host Name. The olehlp!

Servers 40
article thumbnail

Create Table – Disk vs In-Memory Optimized

SQL Server According to Bob

The creation of the XTP, common access DLL requires SQL Server to generate C code, invoke the C compiler and save the DLL into the XTP directory. Bob Dorr – Principal Software Engineer SQL Server. These are additional steps that a disk based table does not perform.

C++ 40