Page Free Space

This article was originally published on 𝕏. SQL Server provides a way to select any one row from a group of rows, provided you write the...

This article was originally published on 𝕏. Introduction Microsoft encourages us not to use the datetime data type: Avoid using date...

Importing a File in Batches There are a million ways to import data into SQL Server. Most of the time, we want to inges...

Fun with Scalar and Vector Aggregates There are interesting things to be learned from even the simplest queries. For e...

Is Distinct Aggregation Still Considered Harmful? Back in 2008, Marc Friedman of the SQL Server Query Processor Team wr...

How Parallelism Works in SQL Server You might have noticed that January was a quiet blogging month for me. Part of the...

Sorting, Row Goals, and the TOP 100 Problem When you write a query to return the first few rows from a potential result...