Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,871 through 45,885 (of 59,101 total)

RE: Hidden RBAR: Triangular Joins

Caleb (1/16/2009)
Thanks Jeff. In your example, I presume everyone would be running around trying to figure out why tempdb was filling up and without 2005's dmvs would find that task...
--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 1:26 pm

#928493
RE: Which SQL would run faster?

leonp (1/16/2009)
ok now that things are returning to normal do we think ISNULL performing better than COALESCE for checking a single operand is no co-incidence?
I don't believe they intentionally did...
--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 1:08 pm

#928480
RE: Phone Numbers Table Design

Krishna_DBA (1/16/2009)
According to Abhijits design, I would have to create 6 unique ID's If a particular customer has 6 work phone numbers. is that right??
That's correct... and you shouldn't have...
--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 1:03 pm

#928471
RE: Phone Numbers Table Design

By the way... if you do contact CCMI, the wizard behind the curtain that makes it all work is called Ed Sullivan. Laugh if you want, that's his real...
--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 1:00 pm

#928469
RE: Phone Numbers Table Design
Jack Corbett (1/16/2009)
Interesting, Jeff. I am in process of developing a system that needs to handle international phone numbers and we decided to go with this design:
Countries (country_code (iso),...
--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 12:56 pm

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

By the way, Julie... what does the prefix "Wrt" stand 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 12:33 pm

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

Very cool and great explanation of the problem you were trying to solve. Thanks a huge amount for taking the time to post it, Julie! 🙂
--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 12:27 pm

#928442
RE: Which SQL would run faster?

GilaMonster (1/16/2009)
Jeff Moden (1/16/2009)
I'm trying to be as nice as pie... I don't understand why people post code and ask which will be faster... that's pretty lazy...
Cause it's easier...
--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 12:22 pm

#928437
RE: Which SQL would run faster?

leonp (1/16/2009)
ok ok ..... spare me the barrage, smart, sweet people ..... you were right .... 1st and 2nd were quicker than 3rd and in fact 1st was quicker...
--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 12:17 pm

#928428
RE: Which SQL would run faster?

leonp (1/16/2009)
alrite ... first thanks for 'all the guidance' ....
second .. while i admit to being a little lazy, I do not have access to the database itself that...
--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 12:13 pm

#928425
RE: Hidden RBAR: Triangular Joins

magarity kerns (8/15/2008)
By the most amazing coincidence, we have just discovered a developer's query is running out of tempdb space because of the following as his join clause:
where
a.acct_nbr >...
--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 12:02 pm

#928413
RE: Hidden RBAR: Triangular Joins

leon mckay (1/16/2009)
Jeff Moden (1/16/2009)
The article was actually first published on 12/6/2007 and it actually says that on the SSC home page where the article was listed. Why they...
--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 11:55 am

#928405
RE: Hidden RBAR: Triangular Joins

Dan Guzman (1/16/2009)
I'm confused. The article states it was published today 1/16/2009, yet this discussion was started 12/6/2007! Even the first 9 pages of responses are from 2007....
--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 10:55 am

#928354
RE: Hidden RBAR: Triangular Joins

sknox (1/16/2009)
Back to the subject, this is a good article. It explains to me exactly why a few queries I've written take so long to run, and I look forward...
--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 10:52 am

#928348
RE: Hidden RBAR: Triangular Joins

sfrazier (1/16/2009)
OK I am a simplistic TSQL programmer - I appreciated the article. I am working on some code in a payroll extract project and have run squarely into...
--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 10:49 am

#928345

Viewing 15 posts - 45,871 through 45,885 (of 59,101 total)