> And trying to teach a subject-matter expert how to 'do' IT is equivalent to teaching an actor how to dance.

MMM... usually, but not always.  I'd love to have a...

I have never used temporary sprocs, in fact I didn't know they existed <g>.

But to answer "when would they be useful", for you (Jeff) and danielk1, I thought there was...

Oops, Hang Liu, let me clarify something in turn:

ease of use refers to the data model’s usage from the report writer’s perspective, not necessarily the end user or self-service perspective....

Hi Hang Liu,

Everything you're saying makes sense to me.  Thank you.  I am 100% sure I would "graduate" from the FKs in the fact table to additional dimensional work if...

@jeff,

Wait ... what?  I apologize, in that case, because all this time I thought you were arguing on the side of perf and resource usage, and all I...

Hi Hang Liu,

Thank you again for your article and for this neat summary of the questions and trade-offs.  I'm glad you are continuing the series.

>While this solution may not integrate...

> Did you find it necessary to use temporal range tables, like the one in this article, to solve for those questions?  That's really what started this whole conversation.

Of course...

Yep, Jeff, here's the very crux of it:

"Better" has many facets to consider... accuracy, performance, resource usage, easy of usage, etc.

I'm going to say a lot of things below, because...

• This reply was modified 10 months, 2 weeks ago by  Lisa Slater Nicholls.
• This reply was modified 10 months, 2 weeks ago by  Lisa Slater Nicholls.

Fair point @jeff, but I think Ron and many other people who build DWs (or Power BI developers?) are more concerned with making the data, and potential calculations,...

I like this a lot. And will definitely use it, thank you! But this sentence in the article had me scratching my head trying to understand what you were trying...

Take a look at the connection strings here https://www.connectionstrings.com/access/, I am definitely no expert on accessing Access (in fact, when I get it right, it's usually because I've...

> I like the ones that ask a homework question or work related question then delete the question so nobody can find out. - lol

I am guessing the former, unless...

[accidental duplicate post, please delete]

• This reply was modified 1 year, 3 months ago by  Lisa Slater Nicholls. Reason: [accidental duplicate post, please delete]

Agreed, nice approach, and I like that it is generic.  I'm going to offer an alternative that has worked for me a lot in the past -- the illustration is...

@jeff,

> This is how "myths" and "Best Practices" that aren't get started.

You are, of course, correct, sir.   In pretty much any field.

 >I've also been doing what the original...