Clustered Columnstore Index really hates Updates
First a little background. I’m working on a large fact table that behaves itself as a slowly changing type 2...
2017-01-03 (first published: 2016-12-23)
4,925 reads
Koen Verbeeck
- Twitter: @https://twitter.com/Ko_Ver
- Website: https://sqlkover.com/
- LinkedIn: https://www.linkedin.com/in/kverbeeck/
Master Data Services Error – Missing Temp Directory
I recently had to install SQL Server 2016 again on my Windows 10 machine. This also meant that I had...
2016-12-15
2,014 reads
SSIS Naming Conventions 2.0
People who have been working for a while with Integration Services probably know the legendary blog post by SQL Server...
2016-12-13 (first published: 2016-12-02)
5,387 reads
Problem where you can only browse Google websites
Note: not a SQL/BI related post like usual, but since it’s a common issue I want to share my solution...
2016-12-01
532 reads
SQL Server 2016 service pack 1 is here!
SQL Server 2016 service pack 1 has been released and it is a mayor one! You can download it here.
Why,...
2016-11-30 (first published: 2016-11-22)
2,433 reads
Calculate a semi-additive average in DAX
A semi-additive average? What exactly are you trying to calculate? Let me explain first. A semi-additive measure is a measure...
2016-11-24
1,746 reads
Book Review – Power Pivot and Power BI
Since Power BI is all the rage right now, I was in need of some material to spice up my...
2016-11-21 (first published: 2016-11-15)
2,129 reads
Master Data Services – Database Error has Occured when Publishing Business Rule
I was preparing a demo for a session about the new features of Master Data Services in SQL Server 2016....
2016-11-04 (first published: 2016-10-31)
3,233 reads
First thoughts on Power BI on premises
The wait is over, the Reporting Services team finally released a preview for Power BI Desktop reports hosted on premises...
2016-11-01 (first published: 2016-10-27)
3,456 reads
Master Data Services error – Cannot read configuration file due to insufficient permissions
In preparation of my upcoming webinar on the new features of Master Data Services 2016, I installed MDS on my...
2016-10-23
2,322 reads
Blogs
T-SQL Tuesday #193 - Notes to Self
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
T-SQL Tuesday #193 – Notes to my past self and from my future self
By DataOnWheels
It has been a while since my last T-SQL Tuesday blog. When I saw...
T-SQL Tuesday #193 – Notes to past and future me
The last T-SQL Tuesday of the year is hosted by my good friend Mike...
Forums
MAX_DISPATCH_LATENCY in extended event , is not clearly explained in msdn.
hi, i have checked reducing it increasing it but could not get any...
What is the PRODUCT
Comments posted to this topic are about the item What is the PRODUCT
Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform
Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers