Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,786 through 46,800 (of 59,101 total)

RE: Recommended path for advanced training?

That's a pretty good analogy of the differences between set based and cursors. Now, I know why you write books. 🙂 Well, done, Brandie!
--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)

December 6, 2008 at 8:29 am

#908813
RE: Processing a non-locked row update from within a TRANSACTION

John Barry (12/4/2008)
Jeff,
This is great. You're awesome - thanks so much for your help. Death to RBAR !!!
Regards,
John
Sorry, John... I got way behind on my emails...
First, thanks 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)

December 6, 2008 at 8:23 am

#908811
RE: Power and Deception of CTEs

timothyawiseman (12/5/2008)
To slightly modify a quote from Larry Wall, "SQL is designed to give you several ways to do anything, so consider picking the most readable one."
I'm definitely for 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)

December 6, 2008 at 8:18 am

#908810
RE: Look up a table fields, data type, etc.

bitbucket (12/5/2008)
Jeff
Pickle juice or formaldehyde? With or without pork chops?
Worked on that SP long before I hand the pleasure and enlightenment of reading your articles, and learning from...
--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)

December 6, 2008 at 8:09 am

#908809
RE: Convert Rows to columns so...

fausto usme (12/5/2008)
>>Heh... No matter where it's done, I'll still like to know why the BA thinks >>that listing an unknown number hospital rooms horizontally is the right thing >>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)

December 5, 2008 at 9:12 pm

#908751
RE: Data Vices

pmcpherson (12/5/2008)
I ahve noticed that 2 smokers who don’t know each other will at least say “Hi” when standing next to each other outside. Two non-smokers can sit next...
--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)

December 5, 2008 at 5:23 pm

#908728
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Kris (12/5/2008)
I was reading somewhere that instead of using cross tabs they used inner joins on same table, Is it save to assume that both Pivot and Cross Tabs preform...
--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)

December 5, 2008 at 5:20 pm

#908727
RE: Data Vices

Heh... I do smoke, but it's better than fuming. 😛 and, I drink about 3 to 4 quarts of coffee a day which is still less Caffeine than someone...
--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)

December 5, 2008 at 2:17 pm

#908676
RE: Data Vices

Sorin Petcu (12/5/2008)
Oh, I hate smoking and its effect!! There are many peoples here where I am working who go out of the building and smoke. This is wasting...
--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)

December 5, 2008 at 2:14 pm

#908675
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

That's part of the reason why people still use cross-tabs on the server side... "Respect the pipe!" 😛
--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)

December 5, 2008 at 6:08 am

#908210
RE: Recommended path for advanced training?

Brandie Tarvin (12/5/2008)
Yeah, Jeff'll never hire me. @=)
Jeff Moden (12/4/2008)
correct answer is NOT "When you think there's no other way"
Actually, I must point out that I've run into one...
--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)

December 5, 2008 at 6:03 am

#908205
RE: Advice for array oflarge arrays

Click on my name to the left of this post near my avatar... send me an email.
I'll be happy to look at it through email before you post...
--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)

December 5, 2008 at 5:46 am

#908191
RE: Convert Rows to columns so...

rog pike (12/4/2008)
Exec Rac
@transform='(Room) as Room',
@rows='[Floor]',
@pvtcol='Room',
@from='Rooms',
@defaults1='y',@rank='Room',@racheck='y',@shell='n'
Floor Room1 Room2 Room3 Room4 Room5 Room6
------- ----- ----- ----- ----- ----- -----
Floor 1 101 102 103 ...
--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)

December 4, 2008 at 11:06 pm

#908073
RE: UPDATE SET =NULL running over an hour

Heh... that code never get's past the first 10000... keeps updating the first 10000 over and over and over.
Lemme build a test table, write a bit of code, and I'll...
--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)

December 4, 2008 at 7:32 pm

#908042
RE: Look up a table fields, data type, etc.

bitbucket (12/4/2008)
And the gods of T-SQL preserve me
Pickle juice or formaldehyde? With or without pork chops? 😛
--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)

December 4, 2008 at 7:23 pm

#908040

Viewing 15 posts - 46,786 through 46,800 (of 59,101 total)