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,159 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,074 reads
Learn how trusted foreign keys (FK) can help or hurt performance.
2018-08-24 (first published: 2016-03-08)
6,818 reads
2015-12-14
1,469 reads
2015-12-07
1,373 reads
2015-11-30
1,312 reads
2015-11-19
1,617 reads
2015-11-13
1,364 reads
2015-11-09
1,622 reads
2015-11-03
1,793 reads
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Hi I have an overnight process that moves allot of claims records Been working...
Comments posted to this topic are about the item Unlocking Data Transformation: My journey...
Comments posted to this topic are about the item Putting the Player with the...
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers