CTE performance

Question

CTE performance

Viewing 5 posts - 61 through 64 (of 64 total)

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

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

kazim.raza (5/13/2010)
Lol... So far so good.. both the design and our 'friend' 😛
I want to discuss that with you... how about if get you the schema of our data mart? Are you willing to brainstorm on it with me?
~ Kazim Raza

That sounds like a fair bit of time would be involved. I don't mind answering a couple of questions but I'd prefer it if this thread didn't turn into a full time job. 😉

--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)

kazim.raza SSCrazy Points: 2390 More actions · Answer 2

Certainly not; or else; what will our friend do 😛

By brainstorming I meant just to take a high level review or opinion...

~ Kazim Raza

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

kazim.raza (5/14/2010)
Certainly not; or else; what will our friend do 😛
By brainstorming I meant just to take a high level review or opinion...
~ Kazim Raza

You should know me by now... I don't have a problem with that. And whether or not something is done correctly in my opinion, it's always good to see other ways of doing things.

--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)

aabrar.jnu Newbie Points: 5 More actions · Answer 4

The CTE was introduced into standard SQL in order to simplify various classes of SQL Queries for which a derived table just wasn't suitable. For some reason, it can be difficult to grasp the techniques of using it. Well, that's before Rob Sheldon explained it all so clearly for us.

"Hyundai Veracruz Parts

"

Jeff Moden SSC Guru Points: 1004415 More actions · Answer 5

aabrar.jnu (5/16/2010)
The CTE was introduced into standard SQL in order to simplify various classes of SQL Queries for which a derived table just wasn't suitable. For some reason, it can be difficult to grasp the techniques of using it. Well, that's before Rob Sheldon explained it all so clearly for us.
"Hyundai Veracruz Parts
"

It's not the CTE that's the problem here. Kazim has a handle on that. It's what the CTE is being used for that's the problem...

--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)