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,752 reads
The LAG function can really improve performance over the old double JOIN.
2019-01-21 (first published: 2019-01-14)
3,752 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,527 reads
A start at identifying and creating TSQL statements for tables that may benefit from compression.
2011-01-13
4,547 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Pro SQL Server Internals
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Comments posted to this topic are about the item Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers