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
61 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
61 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
376 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
92 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
132 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
135 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
64 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers