The Curious Case of… the 8060-byte row size limit

Posted on: March 11, 2020 1:24 pm

The Curious Case of… restoring a table into a different database

Posted on: February 9, 2020 2:17 pm

New VLF status value

Posted on: September 20, 2018 2:27 am

SQLskills SQL101: Why does my heap have a bunch of empty pages?

Posted on: January 24, 2018 11:11 am

SQLskills SQL101: Running out of ints and bigints

Posted on: October 3, 2017 8:39 am

How are default column values stored?

Posted on: April 26, 2017 12:36 pm

SQLskills SQL101: Restoring to an earlier version

Posted on: April 20, 2017 10:50 am

Why PFS pages cannot be repaired

Posted on: March 5, 2017 4:15 pm

Investigating the proportional fill algorithm

Posted on: October 4, 2016 4:58 am

When heap data pages become linked…

Posted on: September 22, 2016 1:32 pm

Data recovery: investigating weird SELECT failures around corruption

Posted on: December 3, 2015 12:20 pm

Incomplete checkpoints and recovery

Posted on: March 18, 2015 12:13 pm

Are mixed pages removed by an index rebuild?

Posted on: June 10, 2014 10:15 am

Inside the Storage Engine: How are allocation unit IDs calculated?

Posted on: November 5, 2013 1:42 pm

New script: When were the sp_configure options last changed?

Posted on: April 26, 2012 11:30 am

Where are sp_configure settings stored? Another reason to backup master…

Posted on: April 26, 2012 10:15 am

How are per-column modification counts tracked?

Posted on: March 13, 2012 11:30 am

Initial VLF sequence numbers and default log file size

Posted on: September 13, 2011 11:52 am

Performance issues from wasted buffer pool memory

Posted on: June 1, 2011 10:13 am

Survey: how much server memory is being wasted? (code to run)

Posted on: April 15, 2011 8:52 am

Do changes to index keys really do in-place updates?

Posted on: February 25, 2011 9:22 am

A SQL Server DBA myth a day: (25/30) fill factor

Posted on: April 25, 2010 9:51 am

Sample corrupt databases to play with

Posted on: February 26, 2010 12:02 pm

Lock logging and fast recovery

Posted on: November 13, 2009 1:24 pm

How do checkpoints work and what gets logged

Posted on: September 27, 2009 9:28 pm

CHECKDB From Every Angle: How to tell if data purity checks will be run?

Posted on: August 19, 2009 11:04 am

Forwarding and forwarded records, and the back-pointer size

Posted on: August 10, 2009 10:53 am

How expensive are page splits in terms of transaction log?

Posted on: May 12, 2009 5:50 pm

Misconceptions around adding columns to a table

Posted on: May 6, 2009 3:38 pm

Misconceptions around null bitmap size

Posted on: May 4, 2009 2:47 pm

Misconceptions around TF 1118

Posted on: April 23, 2009 9:19 pm

Inside the Storage Engine: More on the circular nature of the log

Posted on: April 21, 2009 12:42 am

Msg 602, Level 21, State 50, Line 1

Posted on: March 25, 2009 8:13 am

IAM page corruption examples

Posted on: March 22, 2009 6:14 am

Ghost cleanup redux

Posted on: March 19, 2009 10:44 am

FILESTREAM directory structure

Posted on: March 11, 2009 3:50 pm

Search Engine Q&A #27: How does the storage engine find variable-length columns?

Posted on: March 1, 2009 10:42 am

Corruption errors: Msg 5242, Level 22

Posted on: February 13, 2009 3:33 pm

TechNet Magazine: feature article on understanding logging and recovery

Posted on: January 16, 2009 10:01 am

Corruption bug that people are hitting: Msg 8914 – PFS free space

Posted on: November 6, 2008 11:51 pm

How the on-disk data structures fit together

Posted on: September 8, 2008 4:31 am

Search Engine Q&A #26: Myths around causing corruption

Posted on: August 27, 2008 5:11 pm

Search Engine Q&A #24: Why can’t the transaction log use instant initialization?

Posted on: August 20, 2008 7:47 pm

Search Engine Q&A #21: File header pages, and file header corruption

Posted on: July 25, 2008 2:10 pm

Search Engine Q&A #20: Boot pages, and boot page corruption

Posted on: July 11, 2008 12:01 am

CHECKDB From Every Angle: Using DBCC PAGE to find what repair will delete

Posted on: June 9, 2008 3:54 pm

New script: How much of the database has changed since the last full backup?

Posted on: April 8, 2008 4:49 pm

Inside The Storage Engine: Does turning on page checksums discard any torn-page protection?

Posted on: March 21, 2008 11:23 pm

SQL Server 2008: New (undocumented) physical row locator function

Posted on: March 20, 2008 12:25 am

Inside The Storage Engine: GAM, SGAM, PFS and other allocation maps

Posted on: March 14, 2008 3:31 am

Inside The Storage Engine: sp_AllocationMetadata

Posted on: March 12, 2008 10:38 pm

Inside the Storage Engine: When do versioning tags get added?

Posted on: December 31, 2007 8:53 pm

Search Engine Q&A #10: When are pages from a truncated table reused?

Posted on: December 5, 2007 7:37 pm

How can data-type choice affect performance?

Posted on: November 9, 2007 10:31 pm

Tool for estimating the size of a database

Posted on: October 19, 2007 7:26 pm

Inside the Storage Engine: Ghost cleanup in depth

Posted on: October 8, 2007 4:24 pm

Indexes From Every Angle: What happens to non-clustered indexes when the table structure is changed?

Posted on: October 5, 2007 12:52 am

Inside the Storage Engine: Proof that records are not always physically stored in index key order

Posted on: October 4, 2007 3:29 pm

Inside the Storage Engine: IAM pages, IAM chains, and allocation units

Posted on: October 4, 2007 12:42 am

Inside the Storage Engine: Anatomy of an extent

Posted on: October 3, 2007 10:13 pm

Inside the Storage Engine: Anatomy of a page

Posted on: October 3, 2007 6:49 pm

Inside the Storage Engine: Using DBCC PAGE and DBCC IND to find out if page splits ever roll back

Posted on: October 1, 2007 1:53 am

Inside the Storage Engine: Anatomy of a record

Posted on: September 30, 2007 4:57 pm