Remove c
article thumbnail

Create Table – Disk vs In-Memory Optimized

SQL Server According to Bob

The test being executed was a tight loop of create table statements. 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.

C++ 40
article thumbnail

SQL Server on Linux: ELF and PE Images Just Work

SQL Server According to Bob

I spent a year making plans to for the support changes needed, providing supportability feedback, testing debugger extensions and engaging in many other aspects of the project. By March of 2016 Slava had convinced me to join the team. int c = a + b; 0134167C 8B 45 F8 mov eax,dword ptr [a]. He started me off with an easy project.

Servers 40
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

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

SQL Server According to Bob

Testing shows that by using the Fua bit with the data, write request can reduce the I/O traffic by ~50% for a SQL Server, write-intensive workload. During my investigation, I traced, tested, reviewed, and instrumented the Linux kernel to understand the SQL Server I/O durability needs and associated impacts. Starting with the Linux 4.18

Servers 90
article thumbnail

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

SQL Server According to Bob

extern “C” { extern struct xa_switch_t msqlsrvxa1; }. #include “stdafx.h” ” #include “windows.h” ” #include “xa.h” ” #include “sql.h” ” #include “sqlext.h” ” #include “sqltypes.h” ” #include “odbcss.h”

Servers 40