The SQL Server LAG Function
The LAG function can really improve performance over the old double JOIN.
2019-01-21 (first published: 2019-01-14)
3,812 reads
The LAG function can really improve performance over the old double JOIN.
2019-01-21 (first published: 2019-01-14)
3,812 reads
Scalar functions in Query Plans just don't always show the whole story!
2018-06-04
923 reads
Covering indexes help UPDATE performance also
2018-05-15
12,536 reads
A start at identifying and creating TSQL statements for tables that may benefit from compression.
2011-01-13
4,549 reads
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Comments posted to this topic are about the item From SQL Server On-Premises to...
Comments posted to this topic are about the item Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers