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
87 reads
Joyful Craftsmen Blog
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
722 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
112 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
149 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
152 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
81 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers