Columnstore indexes - The Fast and the Furious

By Koen Verbeeck on 04 December 2018

In-memory columnstore databases are all the rage nowadays. But did you know SQL Server already used them back in 2012? The release of SQL Server 2012 introduced columnstoreindexes to the SQL Server database engine for the first time ever. Borrowing technology from the Power Pivot engine (now found in Power BI), these indexes drastically improve the performance of large analytical queries – exactly the kind of queries used in data warehouses.

Continue Reading

Integration Services: To Log or not to Log?

By Koen Verbeeck on 14 August 2017

When it comes to logging execution information in Integration Services, there are multiple options available. Do you take matters in your own hands and build your own custom logging framework? Or do you let the catalog take care of things?

Can't decide? Check out our guidelines and tips on logging in your SSIS packages and projects.

Continue Reading

How to use Composite Indexes

By Gert Nelissen on 13 June 2014

You might be a developer like me. You might also wander around in the deep and dark layers of relational database systems. You might've been face to face with this thing some call a composite index.

Why are you talking in this denigrating tone?

Because in the fairly limited experience I have, I have seen some grave cases of index abuse. Of them, badly designed composite indexes - or multi-column indexes - were always the most aggravating ones.

Continue Reading

Lists by Topic

see all

Posts by Topic

see all