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)
10,793 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)
3,955 reads
Learn how trusted foreign keys (FK) can help or hurt performance.
2018-08-24 (first published: 2016-03-08)
6,729 reads
2015-12-14
1,461 reads
2015-12-07
1,369 reads
2015-11-30
1,307 reads
2015-11-19
1,610 reads
2015-11-13
1,358 reads
2015-11-09
1,609 reads
2015-11-03
1,786 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...