CCI Bulk Load Pitfalls 2 – Parametrization of Dynamic SQL
Intro
In the last blog I showed how important statistics are for CCI bulk load even on small tables. This time...
2018-09-26
145 reads
Intro
In the last blog I showed how important statistics are for CCI bulk load even on small tables. This time...
2018-09-26
145 reads
Introduction
In this blog post, I would like to explain what a columnstore segment elimination is and how to load data...
2018-09-11
178 reads
Intro
I would like to start a miniseries of blogs where I try to summarize lessons learned from large data loading...
2018-09-03
71 reads
Intro
Intro
I have recently faced the issue of handling big numbers in SSAS Tabular. Our SSAS model processes accounting data for...
2018-07-27
518 reads
Intro
I’m working on a solution where warehouse uses string codes as the keys for dimensions. Therefore the fact table is...
2018-05-23
97 reads
Intro
I’ve written a couple of article about IF & SWITCH in DAX over the past few years. Recently I noticed that...
2018-01-31
139 reads
What are the limits?
What are the limits?
Of course, as a follow-up to my last article you might ask at least...
2017-11-29
141 reads
Issue
Recently we came across an interesting issue. I guess this will not happen often, but I think it’s worth mentioning...
2017-11-20
73 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Can/Can't Do/Don't
Comments posted to this topic are about the item Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers