New posts in Database Internals

In Search of FILESTREAM Insider Information

SQL Server 2014 compression and maximum row size

How does SQL Server handle the data for a query where there is not enough room in the buffer cache?

Why does nested loops join only support left joins?

What is the maximum number of local variables that can participate in SET operation?

PostgreSQL 9.6 column dropping and side-effects on SQL functions with CTEs

Can a plan "age" reach zero?

SUM of DATALENGTHs not matching table size from sys.allocation_units

Changing a column from NOT NULL to NULL - What's going on under the hood?

Why disabling a clustered index makes the table inaccessible?