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,924 reads
Koen Verbeeck
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,010 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,380 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
529 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,742 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
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,126 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,232 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,453 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,319 reads
Blogs
SQL Server Alerts
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
Prompt AI helping with Auditing
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Was the index created or not?
Hi everyone I am getting an error when I create the index but I...
SSIS Package is reporting successful however is short 80-100k records
Good morning all, I have been running into a very random weird issue that...
Question of the Day
Estimated Rows
I have two calls to the GENERATE_SERIES TVF in this code:
SELECT TOP 10 gs.value FROM GENERATE_SERIES(1, 10) AS gs ORDER BY NEWID () OPTION (RECOMPILE); go DECLARE @a int = 10; SELECT TOP (@a) gs.value FROM GENERATE_SERIES(1, @a) AS gs ORDER BY NEWID () OPTION (RECOMPILE);In the actual query plans, what is the estimated number of rows for each batch in SQL Server 2022? See possible answers