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,976 reads
The LAG function can really improve performance over the old double JOIN.
2019-01-21 (first published: 2019-01-14)
3,976 reads
Scalar functions in Query Plans just don't always show the whole story!
2018-06-04
936 reads
Covering indexes help UPDATE performance also
2018-05-15
12,568 reads
A start at identifying and creating TSQL statements for tables that may benefit from compression.
2011-01-13
4,564 reads
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Comments posted to this topic are about the item Hyperscale Replicas I
Comments posted to this topic are about the item The End of Summer
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers