Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Hugo Kornelis

SQLServerCentral.com profile

   Items 1 to 10 of 10   
 

Stairway to Columnstore Indexes Level 9: Batch Mode Execution

In this level, Hugo explains what batch mode execution is, how it differs from row mode execution, and what its limitations are.  Read more...
By Hugo Kornelis 2016/08/31 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 726 reads

Stairway to ColumnStore Indexes Level 7: Optimizing Nonclustered Columnstore Indexes

In this level, we will focus on optimization techniques to apply while building the nonclustered columnstore index, which is available in all versions of SQL Server from 2012 up.  Read more...
By Hugo Kornelis 2016/03/16 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,611 reads

Trust, or Verify – How FKs Can (or Cannot) Help Performance

Learn how trusted foreign keys (FK) can help or hurt performance.  Read more...
By Hugo Kornelis 2016/03/08 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 3,212 reads

Stairway to Columnstore Indexes Level 6: Updating and Deleting Data in a Columnstore Index

This level looks in detail at what happens when we update or delete data from a clustered columnstore index, the impact it has on concurrent data access, and how without careful maintenance the efficiency of columnstore indexes can degrade over time.  Read more...
By Hugo Kornelis 2016/01/20 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,583 reads

Stairway to Columnstore Indexes Level 5: Adding New Data To Columnstore Indexes

Earlier levels have shown how Columnstore Indexes work effectively with static data. In most tables however, data is hardly ever static. We are constantly inserting new rows, and updating or deleting existing rows. If you think about what this means for a columnstore index, you will realize that this comes with some unique challenges.  Read more...
By Hugo Kornelis 2015/11/04 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,926 reads

Stairway to Columnstore Indexes Level 4: Catalog Views

In this level, we will first take a look at how to recognize columnstore indexes in some of the generic catalog views. After that we will investigate the new catalog views that have been added just for columnstore indexes.  Read more...
By Hugo Kornelis 2015/08/05 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,952 reads

Stairway to Columnstore Indexes Level 3: Building The Columnstore

The performance increase columnstore indexes grant when reading data from the index is offset by the expensive process required to build the index. In this Stairway level, Hugo Kornelis walks you through the steps SQL Server takes when building (or rebuilding) a columnstore index.  Read more...
By Hugo Kornelis 2015/06/10 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,998 reads

Stairway to Columnstore Indexes Level 2: Columnstore Storage

To fully appreciate just how different columnstore indexes are, and why work so well in reporting and online analytical processing (OLAP) workloads, but not for online transaction processing (OLTP), we must first look at the traditional “rowstore” indexes.  Read more...
By Hugo Kornelis 2015/04/29 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,831 reads

Stairway to Columnstore Indexes Level 1: A First Look At Columnstore Indexes

This level introduces of you to the fundamentals of columnstore indexes, introdused in SQL Server 2012 to manage the indexing of very large tables.  Read more...
By Hugo Kornelis 2016/05/30 (first published: 2015/02/25) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,984 reads
   Items 1 to 10 of 10