Archive for the ‘Workload & Capacity Planning’ Category

How to Process a SSAS MOLAP cube as fast as possible – Part 2 (2014-3-9)

Special thanks to Dirk Gubbels for his contribution on the data type optimization part and review!(Follow Dirk on Twitter: @QualityQueries). In part 1 we looked at a method to quantify the work that gets done by SQL Server Analysis Server and found that the OLE DB provider with a network packet size of 32767 brings […]

Introduction to SQL Server 2012 Parallel Data Warehouse (2013-12-25)

Surprisingly how we over the years have accepted that we need to invest a lot of time and energy to move data from ‘A’ to ‘B’  and to maintain a well performing data warehouse platform where your reports & queries respond within a reasonable amount of time (and I’m not referring to just SQL Server […]

Better Tag Cloud