SQL Server Science

Technical Articles for the DBA / Developer

Home » Page 20

A Tour of SQL Server Page Types: Data, GAM, SGAM, PFS, IAM

2026-07-21 · by Hannah Vernon · in Internals

Most of this storage series has been spent inside data pages, pulling rows apart byte by byte. But a data file is not only data pages. Scattered through it, at fixed and predictable spots, are…

Forwarded Records: What an UPDATE Can Do to a Heap

2026-07-20 · by Hannah Vernon · in Internals

This post is part of the series. The contents page lists every part in order. A heap, a table with no clustered index, has a failure mode that clustered tables do not: an UPDATE that…

Row-Overflow and LOB: When a Row Leaves the Page

2026-07-19 · by Hannah Vernon · in Internals

This post is part of the series. The contents page lists every part in order. A data page is 8 KB, and a single row is capped at 8,060 bytes of in-row data.[1] So what…

How SQL Server Packs BIT Columns Into a Single Byte

2026-07-18 · by Hannah Vernon · in Internals

This post is part of the series. The contents page lists every part in order. A common worry about bit columns is that a table full of yes/no flags will waste a byte on every…

The NULL Bitmap: How SQL Server Records Nullability

2026-07-17 · by Hannah Vernon · in Internals

Every SQL Server data row carries a NULL bitmap, even a table with no nullable columns. Find it on the page, watch the bits flip as columns go NULL, and see what it actually costs.

How SQL Server Stores MONEY and SMALLMONEY, and the Rounding Trap

2026-07-16 · by Hannah Vernon · in Internals

money and smallmoney are just integers scaled by 10000. The real page bytes, why the ranges are what they are, and the four-decimal truncation trap that bites calculations.

« Previous 1 … 19 20 21 … 64 Next »

Search

Categories

  • AI for DBAs
  • announcements
    • events
  • basics
    • localization
  • configuration
  • Data Architecture
  • DMVs
  • documentation
  • extended-events
  • Git for DBAs
  • High Availability
  • Hot Takes
  • Internals
  • maintenance
    • patching
  • Opinion
  • performance
  • PostgreSQL
  • Professional Development
  • recovery
  • reporting
  • ROLLBACK;
  • security
    • data security
  • service broker
  • SQL Server Agent
  • statistics
  • sys
  • t-sql
    • xml
  • tools
    • data masking
    • wsus
  • troubleshooting
  • Uncategorized

Pages

  • About SQL Server Science
  • Blog Series
    • Backup & Recovery from First Principles: Series Contents
    • Database as a Versioned Contract: Series Contents
    • Extended Events in Production: Series Contents
    • Git for DBAs: Series Contents
    • How SQL Server Stores Data: Series Contents
    • Logins, SIDs, and Kerberos from First Principles: Series Contents
    • Proving the Restore: Series Contents
    • T-SQL Style Guide, Tested: Series Contents
    • The UNKNOWN Problem: NULL Traps in T-SQL, Series Contents
    • Undocumented Changes in SQL Server 2022 and 2025: Series Contents
    • Work That Flows: Kanban for DBAs: Series Contents
  • Get Better Help with a Minimal, Complete, and Verifiable Example, or MCVE
  • Privacy Policy

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.

To find out more, including how to control cookies, see here: Cookie Policy

Copyright © 2026 SQL Server Science