Internal Query Processor Error Debugged
In Joyful Craftsmen we provide, among other things, technical support to our customers, which from time to time involves us...
2018-10-16
866 reads
CCI – Data Loading considerations with Partitioned Tables and CCI
Introduction
In this blog post, I would like to describe two case scenarios of bulk loading data, using SSIS, into a...
2018-10-10
269 reads
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
146 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
179 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
72 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
529 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
101 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
140 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
143 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
73 reads
Blogs
Why is shrinking IT budgets a good thing?
Each year around this time, companies enter the familiar ritual of budgeting. For many,...
Reverse Engineering a Physical Model Diagram
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
Prepping for Certification, Part 3 of ?
By Brian Kelley
After I have understood the details for a certification test (part 1), including format...
Forums
Best analysis approach to reduce data type length in multiple tables
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Do you separate data/log files and TempDB files on different disks using AWS EC2
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Service account being in local admin in AWS EC2 environment?
Hello, I am working with a company on their database administration. I am trying...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers