In Level 7, we looked at optimizing rowgroup elimination for a nonclustered columnstore index. For a clustered columnstore index, the same technique can be used but the steps and syntax change a bit. This will be covered later – but first, let’s take a look at another significant difference between nonclustered and clustered columnstore indexes, […]
2019-03-26 (first published: 2018-06-20)
11,141 reads
In this level, Hugo explains what batch mode execution is, how it differs from row mode execution, and what its limitations are.
2019-03-26 (first published: 2016-08-31)
4,064 reads
Learn how trusted foreign keys (FK) can help or hurt performance.
2018-08-24 (first published: 2016-03-08)
6,802 reads
2015-12-14
1,469 reads
2015-12-07
1,372 reads
2015-11-30
1,311 reads
2015-11-19
1,616 reads
2015-11-13
1,364 reads
2015-11-09
1,619 reads
2015-11-03
1,791 reads
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
By Brian Kelley
I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...
Comments posted to this topic are about the item Create an HTML Report on...
While doing some housekeeping activity on several old but large production databases, I come...
How important to SQL Server is the speed of the SSD and network latency?...
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers