SQL Server According to Bob

Two guys who work on SQL Server

Tag: File I/O

SQL Server I/O Basics Chapter #2

Additional details of SQL Server I/O patterns and capabilities.

Read More

SQL Server I/O Basics Chapter #1

Fundamental SQL Server I/O patterns and capabilities.

Read More

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

  Overview 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 Durability: “In database systems, durability is the ACID property which guarantees transactions that have committed will survive permanently. For example, if a flight […]

Read More