May 1, 2017 | SQL Server, Technical Information
By: Paul Schuliger BI Consultant at Key2 Consulting This is the second article about the use of the Date Matrix in reporting applications. The first article can be found here if you missed it. The Date Matrix is a SQL tool that is used to solve the problem of...
Mar 9, 2017 | Data Visualization, Microsoft Power BI, Technical Information
By: Matt Wollner Sr. Business Intelligence Consultant at Key2 Consulting I’ve spent a lot of time talking to business owners and managers. And I’ve noticed that many of these leaders tend to use excel for their analytics needs. Furthermore,...
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...
Dec 21, 2016 | SQL Server, Technical Information
Buzz on the street lately is that a Memory Optimized Table (MOT) in SQL Server greatly enhances OLTP SELECT performance. People in the industry are saying this because an entire table can be loaded completely into SQL Server memory without the unfortunate occurrence...
