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
CCI – How to load data for better Columnstore Segment Elimination
Introduction
In this blog post, I would like to explain what a columnstore segment elimination is and how to load data...
2018-09-11
177 reads
CCI Bulk Load Pitfalls 1 – ETL Framework and up-to-date Statistics
Intro
I would like to start a miniseries of blogs where I try to summarize lessons learned from large data loading...
2018-09-03
70 reads
How to handle big numbers in SSAS Tabular
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
513 reads
SSAS Tabular – Fact Table Key Columns Datatype Impact
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
DAX IF & Switch Statement Performance – Does Order Matter?
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
SSAS Tabular – Large Dimension Performance II
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
139 reads
SSIS script task successfully executed. Or not?
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
72 reads
Blogs
AI Model Size, Parameters and Download
By Steve Jones
At SQL Saturday Boston 2025, I gave a presentation on local LLMs and there...
Expanding Your DBA Horizons: Installing PostgreSQL in a Home Lab
By gbargsley
Are you diversifying your DBA skillset? My recent job search made one thing clear:...
Back in the EU
By Steve Jones
I flew to Amsterdam last night and hopefully by the time this publishes I’ll...
Forums
caught off guard by some greek lettering in a warehouse feed
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Vector Datatype
Comments posted to this topic are about the item Vector Datatype
Question of the Day
Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers