The Data Model Matters

Question

Post reply

The Data Model Matters

Steve Jones - SSC Editor

SSC Guru

Points: 742261
More actions
June 5, 2026 at 12:00 am

#4839538

Comments posted to this topic are about the item The Data Model Matters

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004725 More actions · Answer 1

From the article:

Build a strong data model and write efficient SQL Code.

Preach it my brother from a another mother. And great article! Thanks, Steve.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 742261 More actions · Answer 2

Lol, so much so. DevOps, AI, everything that can help you move faster doesn't mean you get to ignore good practices, good architecture, and a strong model.

Going faster only happens effectively when you improve the basics.

Jeff Moden SSC Guru Points: 1004725 More actions · Answer 3

There is definitely some truth to the old adage of "The faster I go, the behinder I get".

It also reminds me of "Love Bug" Season in Florida... going faster in your car made a bigger mess.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)