More On Column Order Indexes – Part 2
Continued analysis of index architecture with revised clustered index. Part 2 of Column Order Indexes
2019-04-24
105 reads
Mike Byrd
More On Column Order Indexes – Part 2
Continued analysis of index architecture with revised clustered index. Part 2 of Column Order Indexes
2019-04-09
2,238 reads
Index Column Order – Be Happy!
Ever wonder about index column order; this piece should give some insight.
2019-02-28
1,984 reads
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)
1,793 reads
TOP vs Max/Min: Is there a difference?
Is there a difference between using TOP and MAX/MIN to return and end value to a table?
2018-12-17
1,606 reads
Scalar Functions with Query Plans: Not all is obvious!
Scalar functions in Query Plans just don't always show the whole story!
2018-06-04
828 reads
Covering Indexes: Not Just for SELECT but also for UPDATE statements
Covering indexes help UPDATE performance also
2018-05-15
1,529 reads
A Collaborative Approach To Table Compression
A start at identifying and creating TSQL statements for tables that may benefit from compression.
2011-01-13
4,486 reads
Blogs
Information Measurement with SQL Server Part 4.5: The Squared L2 Family of Distances
By Steve Bolton …………In the last two installments of this series of amateur self-tutorials...
Security Learning Pathway at PASS Summit.
This year PASS is trying something new at PASS Summit. There are going to...
Pathways to Progress
One of the most significant and hardest challenges we face as data professionals (or...
Forums
error Output File cleanup does not delete files script d'olla
Hello everyone, I use olla scripts in my backup and maintenance operations there is...
Help with a stored procedure
I have a table "Mytable" containing a list of IDs. There is a web...
Need to perform leaf level aggregation
So I have a DW with a table with some pre-aggregated scores (not my...
Ask SSC