Feb 27, 2017 | Data Warehousing, Featured, SQL Server, Technical Information
By: Ken Adams Sr. Business Intelligence Consultant at Key2 Consulting A junk dimension is seen occasionally inside of data warehouses. This type of dimension can be thought of as a flag table, or a collection of attributes that have low-cardinality. This...
Feb 20, 2017 | SQL Server, Technical Information
Choosing the right index for Memory Optimized Tables (MOTs) In Part 1 of our investigation into In-Memory Tables, we saw how changing a Hash Index to a regular Nonclustered index of a sample database table improved the performance of our Select operation. In this...
Feb 9, 2017 | Business Intelligence, SQL Server, Technical Information
By: Paul Schuliger Business Intelligence Consultant Anyone who’s looked into a master craftsman’s toolbox knows that they keep an extensive variety of tools. So many so, that it seems only half of them are ever used. But the craftsman doesn’t...