Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,446 through 38,460 (of 59,098 total)

RE: CTE performance

The one in probably the most famous article ever when it comes to how to do things using "Nested Set" hierarchies... written by none other than Joe Celko himself...
http://intelligent-enterprise.informationweek.com/001020/celko.jhtml;jsessionid=SDL2T2BF3SLWFQE1GHPSKH4ATMY32JVN
I'll also...
--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)

May 12, 2010 at 3:11 pm

#1166550
RE: checkning for allowable values

Joe Celko (5/12/2010)
Don't use the race codes table; remove the code from the string and see if it has left-overs:
REPLACE('I', '',
REPLACE('N', '',
REPLACE('P', '',
REPLACE('B', '',
REPLACE ( 'W', '', mutli_race_code),
),),),)...
--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)

May 12, 2010 at 1:55 pm

#1166509
RE: checkning for allowable values

lmu92 (5/11/2010)
Jeff Moden (5/10/2010)
As much as I love working with the Tally table, it just doesn't need to be that complicated for this. In fact, the CASE formula in...
--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)

May 12, 2010 at 1:51 pm

#1166506
RE: CTE performance

Heh... see Kazim? I'm not the only one that want's a piece of your "architect". 😉
--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)

May 12, 2010 at 1:08 pm

#1166485
RE: Views Vs Stored Procs

CirquedeSQLeil (5/12/2010)
GilaMonster (5/12/2010)
It depends.
p.s. A 5-table query is not exactly complex.
Agreed.
Heh... it depends. 😛
--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)

May 12, 2010 at 12:58 pm

#1166480
RE: Code generation

scziege (5/12/2010)
Hey Jeff,
our customer want to make a promotion on a product package with this codes.
The customer can buy the product and insert the code onto a web page, after...
--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)

May 12, 2010 at 8:07 am

#1166230
RE: Code generation

Gianluca Sartori (5/12/2010)
Great explanation, Jeff! That's one thing I wanted to ask.
It's strange to see that partition by seems to be faster than distinct. I would have expected to...
--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)

May 12, 2010 at 8:02 am

#1166221
RE: Comparing two rows in one table for changes in column

Dobermann (5/11/2010)
Wow, Jeff! I am going to have to study this one long and hard! Thank you so much - I will post back with either more questions...
--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)

May 12, 2010 at 7:36 am

#1166198
RE: Comparing two rows in one table for changes in column

dmoldovan (5/12/2010)
Dobermann, Jeff, I appologize for being wrong this time. I did not realized in a timely manner the output that Dobermann needs.
Sorry, guys :blush:
Nah... you're alright. I very...
--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)

May 12, 2010 at 7:03 am

#1166165
RE: Comparing two rows in one table for changes in column

The "4th row" does complicate things a bit. You have to reverse the query and run it again and then get rid of the dupes... I think this will...
--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)

May 11, 2010 at 10:42 pm

#1165943
RE: Comparing two rows in one table for changes in column

Dobermann (5/11/2010)
Jeff Moden (5/11/2010)
Heh... you do realize that by using the 2008 VALUES clause, that all of the people still stuck in the world of 2005 or earlier either can't...
--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)

May 11, 2010 at 9:07 pm

#1165930
RE: Comparing two rows in one table for changes in column

dmoldovan (5/11/2010)
I think that a cursor, which accesses the data ordered by date, is useful in your case.
So... let's see the cursor. 😉
--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)

May 11, 2010 at 9:03 pm

#1165928
RE: Comparing two rows in one table for changes in column

Also, didn't eric_russell's code do it for 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)

May 11, 2010 at 8:49 pm

#1165924
RE: Views Vs Stored Procs

koustav_1982 (5/11/2010)
Hi
I have a complex query.
Now this query can be written as
1. A view
2. A stored Procedure
Assume that the query do not accept any parameter .
Which one should...
--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)

May 11, 2010 at 8:41 pm

#1165923
RE: Comparing two rows in one table for changes in column

Heh... you do realize that by using the 2008 VALUES clause, that all of the people still stuck in the world of 2005 or earlier either can't help you or...
--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)

May 11, 2010 at 8:30 pm

#1165920

Viewing 15 posts - 38,446 through 38,460 (of 59,098 total)