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,205 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,087 reads
Learn how trusted foreign keys (FK) can help or hurt performance.
2018-08-24 (first published: 2016-03-08)
6,830 reads
2015-12-14
1,469 reads
2015-12-07
1,375 reads
2015-11-30
1,313 reads
2015-11-19
1,619 reads
2015-11-13
1,368 reads
2015-11-09
1,624 reads
2015-11-03
1,795 reads
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Is there a good syllabus for reading these two together? (Yes, it's called the...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers