Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,941 through 32,955 (of 59,099 total)

RE: Hidden RBAR: Counting with Recursive CTE's

terrance.steadman (8/8/2011)
Greetings Jeff,
That was a wonderful and very insightful article about rCTE's and ways to count out of the box. I will have to put some of the pseudo-counters...
--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)

August 8, 2011 at 12:21 pm

#1365448
RE: Temp table vs Table variable

pkasemsant (8/8/2011)
As developer and still got lots to learn in SQL Server administration, can anyone tell me, which is better using temp table(s) or creating table variable(s) within these conditions,
i....
--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)

August 8, 2011 at 7:54 am

#1365225
RE: What SQL Server Books Do You Recommend

lrobbins (8/8/2011)
I highly recommend subscribing to the SQLServerCentral.com lists. Just skim the e-mail for anything new you want to learn about. If it has nothing, delete it. If it's something...
--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)

August 8, 2011 at 7:41 am

#1365221
RE: Are the posted questions getting worse?

Tom.Thomson (8/8/2011)
Lynn Pettis (8/8/2011)
Obviously anything I have to say is going to be taken the wrong way.
Well, after your earlier reply followed by this which read one after the other...
--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)

August 8, 2011 at 7:36 am

#1365213
RE: Hidden RBAR: Counting with Recursive CTE's

George J Verras (8/8/2011)
Excellent, Thanks Jeff!
You bet, George. Thanks for stopping by and for the feedback.
--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)

August 8, 2011 at 7:24 am

#1365204
RE: Hidden RBAR: Counting with Recursive CTE's

majorbloodnock (8/8/2011)
Sorry, but there's a glaring inconsistency in this article.
No-one with any taste buds would take a perfectly acceptable alcoholic drink and cool it so much that it freezes. 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)

August 8, 2011 at 7:23 am

#1365202
RE: Hidden RBAR: Counting with Recursive CTE's

Henk van den Berg (8/8/2011)
Very insightful article. Thanks.
I have one question, how do you discard the output?
(Anticipating a "slap-to-the-forehead" moment, but asking anyway...)
Best,
Henk
Heh... no problem, Henk. A lot of...
--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)

August 8, 2011 at 7:21 am

#1365200
RE: How will you write a query for this scenario

Ninja's_RGR'us (8/7/2011)
7 straights posts Jeff.
The man's on fire :-D.
Heh... I can't wait for someone to pass me for the number of posts so you'll stop riding my donkey,...
--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)

August 7, 2011 at 8:47 pm

#1365004
RE: Are the posted questions getting worse?

Ninja's_RGR'us (8/7/2011)
Don't get me wrong. I've been on both sides of the equation and I completely agree with your POV. Last week I had a 10 hour non-stop...
--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)

August 7, 2011 at 8:37 pm

#1365002
RE: Are the posted questions getting worse?

Lynn Pettis (8/7/2011)
Someone obviously took exception with my opinion.
He knows not of "Saint Lynn". I thought your response was perfect.
--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)

August 7, 2011 at 8:30 pm

#1364999
RE: How to Become MVP?

Gosh... sorry Remi. If I've told you to read the full thread in the past, I'm sure sorry about that. It's not always possible to have the 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)

August 7, 2011 at 8:22 pm

#1364997
RE: How to Become MVP?

Ninja's_RGR'us (8/7/2011)
@jeff
:Whistling::arrow:
Ninja's_RGR'us (8/5/2011)
Might I point out that using the right nickname is a good start with the basics.
~~kraig~~ Craig :Whistling:
So you don't think it was important enough to mention...
--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)

August 7, 2011 at 8:07 pm

#1364992
RE: How to Become MVP?

@SQLFRNDZ (8/5/2011)
I heard to become MVP, they should be active ob forums and blogs but Is there any certain measures they consider for a MVP?
Ok... I probably shouldn't do this...
--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)

August 7, 2011 at 8:04 pm

#1364990
RE: How to Become MVP?

@SQLFRNDZ (8/5/2011)
Craig Farrell (8/5/2011)
@SQLFRNDZ (8/5/2011)
Thank you for the information.
I was just posted this topic because I see this MVP tag on most sites and blogs of experts and...
--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)

August 7, 2011 at 7:01 pm

#1364974
RE: How to Become MVP?

@SQLFRNDZ (8/7/2011)
Speaking as one who had been nominated, this is not enough.
I thought this forum or thread is to help some one that too regarding SQL server but not 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)

August 7, 2011 at 6:50 pm

#1364966

Viewing 15 posts - 32,941 through 32,955 (of 59,099 total)