Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,841 through 45,855 (of 59,095 total)

RE: Hidden RBAR: Triangular Joins

TheSQLGuru (1/17/2009)
1) IIRC for some of your running total solutions and other set-based examples here (especially the ones using update @var = @var ... trick) you put the entire set...
--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)

January 17, 2009 at 12:48 pm

#928723
RE: Hidden RBAR: Triangular Joins

TheSQLGuru (1/17/2009)
1) there is less tempdb storage overhead to a cursor (some of them anyway) than putting the entire set of data in tempdb.
Heh, ok, you said it, now prove...
--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)

January 17, 2009 at 8:38 am

#928681
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Heh... it'll be interesting to see what sort of panic they go into if they ever go over 17576 customers. Thanks for the great explanation.
--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)

January 16, 2009 at 9:20 pm

#928633
RE: Why do people need to do this?

No, I sure don't, Barry. I looked but I've got so many posts and there's so many wierd post names, I've not been successful at all. Thought I'd...
--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)

January 16, 2009 at 9:08 pm

#928632
RE: Timesheets for DBA/DBDs

If that's true, I'm very happy for me but I'm really sad about the folks they let go. Most of them were really good people that I'd go back-to-back...
--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)

January 16, 2009 at 9:05 pm

#928631
RE: Why do people need to do this?

Understood and much appreciated, Micheal. Thanks. But, look at the data in the example... it's not ranking anything. It's simply building a seqence of how many times...
--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)

January 16, 2009 at 7:49 pm

#928626
RE: Which SQL would run faster?

Thanks Jack... appreciate your time.
--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)

January 16, 2009 at 7:32 pm

#928619
RE: Timesheets for DBA/DBDs

Rayven (1/16/2009)
Jeff: Any jobs going at your place? Initiative here tends to be welcomes with a ".. and why were you wasting company time?" before they have even evaluated the...
--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)

January 16, 2009 at 7:27 pm

#928617
RE: Evaluate a string Expression

smunson (1/16/2009)
Jeff,
I hope you're not lumping me in with the "some answers that aren't quite right" group... at least I was the post with the REPLACE idea for...
--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)

January 16, 2009 at 7:22 pm

#928615
RE: Why do people need to do this?

Piotr Rodak (1/16/2009)
I came across the 'top 5' requirement. I needed to identify rows that have some values not smaller than 5 biggest values in the table. I guess it's...
--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)

January 16, 2009 at 7:18 pm

#928614
RE: Hidden RBAR: Triangular Joins

TheSQLGuru (1/16/2009)
Tempdb constraints come to mind here. 🙂
I sure do wish someone with CLR knowhow (and some free time) would take the opportunity to do some CLR code you...
--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)

January 16, 2009 at 5:15 pm

#928597
RE: SQL Bulk Insert

Does the target table exist to begin with?
--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)

January 16, 2009 at 4:59 pm

#928594
RE: Indexed View ... Slow !?!?

There is no need for a cross-join on the date table to get all of the dates... it should be an outer join, instead. That is likely your performance...
--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)

January 16, 2009 at 4:53 pm

#928593
RE: Hidden RBAR: Triangular Joins

TheSQLGuru (1/16/2009)
Jeff, it strikes me that pretty much all of your examples here and in other threads have a clustered index on the key of concern. What happens when...
--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)

January 16, 2009 at 4:45 pm

#928588
RE: Which SQL would run faster?

I must have something whacky going on with my machine... it gives me an XML error when I try to open the excecution plan.
I have no doubt that the IO...
--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)

January 16, 2009 at 4:34 pm

#928587

Viewing 15 posts - 45,841 through 45,855 (of 59,095 total)