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,709 reads
The LAG function can really improve performance over the old double JOIN.
2019-01-21 (first published: 2019-01-14)
3,709 reads
Scalar functions in Query Plans just don't always show the whole story!
2018-06-04
920 reads
Covering indexes help UPDATE performance also
2018-05-15
12,518 reads
A start at identifying and creating TSQL statements for tables that may benefit from compression.
2011-01-13
4,545 reads
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Comments posted to this topic are about the item Limit the Blast Radius
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers