Skip to main content
Under the kover of business intelligence
  • Home
  • Copyright
  • About

Tag: performance

SSRS and MDX: Think about Cell Properties

May 4, 2016May 4, 2016 Koen Verbeeck Leave a comment

I stumbled across a small MDX performance tuning trick when using SSRS reports (or any other client tool where you can edit the MDX). When you create the MDX query using the designer, it will append some cell properties at the end of the query. Basically it’s just metadata about the cells of the result […]

Read More

Loading Data into Clustered Columnstore Index with SSIS

April 21, 2016April 21, 2016 Koen Verbeeck Leave a comment

I’m using a clustered columnstore index (CCI) on one of my fact tables at a client. The row size is between 8 and 9 million rows and I was wondering how I could load data efficiently in this CCI using SSIS. I stumbled upon this MSDN blog post: SQL Server 2016 SSIS Data Flow Buffer […]

Read More

Reblog: SSIS Performance Testing

February 12, 2016February 12, 2016 Koen Verbeeck 2 Comments

I had to do some performance testing for an MSSQLTips article and I thought I’d share the framework I used in a blog post. First of all we have to log start and end dates of the package to a table so we can easily calculate the duration a package took to finish. This can probably […]

Read More

Book Review – Expert Performance Indexing

February 2, 2016February 2, 2016 Koen Verbeeck Leave a comment

A few weeks back, the folks at Apress Publishing sent me a copy of the book Expert Performance Indexing in SQL Server for me to review. Since I know both the authors and since I’m familiar with the spectacular work they do, I was happy to do so. Doesn’t mean I won’t do an honest […]

Read More

Performance Tuning with sp_BlitzIndex

December 7, 2015December 7, 2015 Koen Verbeeck 3 Comments

Just a small blog post about how I used sp_BlitzIndex for the first and how awesome that was. sp_BlitzIndex is one of the many free scripts you can get from the great team at Brent Ozar Unlimited. Recently I went to a client for a one day data warehouse performance tuning exercise. Because you only have […]

Read More

Feed

RSS

Social

  • Twitter
  • LinkedIn

MVP

Microsoft Data Platform MVP

star schema all the things
Get your star schema merchandise

Author of the Year 2014/2020/2023

Support this blog and buy me a beer

Recent Posts

  • Execute Fabric Data Pipeline from Azure Data Factory
  • Azure Data Factory Pipeline Debugging Fails with BadRequest
  • Call a Fabric REST API from Azure Data Factory
  • Cool Stuff in Snowflake – Part 14: Asynchronous Execution of SQL Statements
  • How I passed the DP-700 Exam

Categories

  • Azure (25)
  • Azure Data Factory (25)
  • Azure Devops (4)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (56)
  • Fabric (19)
  • Power BI (41)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (112)
    • MDS (8)
    • SSAS (12)
    • SSIS (46)
    • SSRS (13)
    • TSQL (9)
  • Varia (37)
  • Twitter
  • LinkedIn
  • Home
  • Copyright
  • About
Under the kover of business intelligence All rights reserved. Theme by Colorlib Powered by WordPress