Page Free Space

SQL Server internals by Paul White

Showing posts with label TSQL. Show all posts
Showing posts with label TSQL. Show all posts
Sunday, 15 September 2024

Current State of the ANY Aggregate Transformation

›
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...
Monday, 12 August 2024

Don't Mix with Datetime

›
This article was originally published on 𝕏. Introduction Microsoft encourages us not to use the datetime data type: Avoid using date...
Wednesday, 2 August 2023

Importing a File in Batches

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

Fun with Scalar and Vector Aggregates

›
Fun with Scalar and Vector Aggregates There are interesting things to be learned from even the simplest queries. For e...
Sunday, 4 December 2011

Is Distinct Aggregation Still Considered Harmful?

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

How Parallelism Works in SQL Server

›
How Parallelism Works in SQL Server You might have noticed that January was a quiet blogging month for me. Part of the...
Friday, 27 August 2010

Sorting, Row Goals, and the TOP 100 Problem

›
Sorting, Row Goals, and the TOP 100 Problem When you write a query to return the first few rows from a potential result...
2 comments:
›
Home
View web version

About Me

My photo
Paul White
View my complete profile
Powered by Blogger.