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,224 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,091 reads
Learn how trusted foreign keys (FK) can help or hurt performance.
2018-08-24 (first published: 2016-03-08)
6,837 reads
2015-12-14
1,471 reads
2015-12-07
1,375 reads
2015-11-30
1,315 reads
2015-11-19
1,621 reads
2015-11-13
1,369 reads
2015-11-09
1,624 reads
2015-11-03
1,795 reads
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers