Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,621 through 43,635 (of 59,097 total)

RE: Are the posted questions getting worse?

Heh... in case anyone is wondering if I simply disappeared on this, the answer is "No". It's just that the freakin' cursor is taking me so long to write....
--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)

June 3, 2009 at 8:31 pm

#1004390
RE: Are the posted questions getting worse?

WayneS (6/3/2009)
I thought you kept those in the s***can?:-D
Heh... you know me too well. Yep... that's where I keep them... right along with those bloody handrails. 😛
--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)

June 3, 2009 at 8:28 pm

#1004388
RE: Are the posted questions getting worse?

Adam Machanic (6/3/2009)
Jeff Moden (6/3/2009)
Heh... how would you use only Read-Only with a cursor and still only be able to return a single result set? Or are you just...
--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)

June 3, 2009 at 6:57 pm

#1004375
RE: Are the posted questions getting worse?

Paul White (6/3/2009)
Adam Machanic (6/3/2009)
This answer surprises me; I thought that given your interest in the technique you would already have an answer here. If not for speed, what's your...
--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)

June 3, 2009 at 6:51 pm

#1004373
RE: Are the posted questions getting worse?

Steve Jones - Editor (6/3/2009)
Jeff, check the MVP offers (private newsgroup). I think SQL Mag will give you a free sub. Heck, you've earned it.
Thanks for the tip, Steve. ...
--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)

June 3, 2009 at 5:42 pm

#1004353
RE: Are the posted questions getting worse?

Adam Machanic (6/3/2009)
Disregarding whether it's a good idea to use, have you seen this method actually yield substantial (say, 50%+) improvements over properly configured cursors (i.e., LOCAL READ_ONLY)?
Heh... how...
--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)

June 3, 2009 at 5:32 pm

#1004351
RE: Are the posted questions getting worse?

john.arnott (6/3/2009)
Before popping $5 for the online access, I think I'll check the magazine section next time I'm at Borders. Not worth a special trip, but I'm there once...
--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)

June 3, 2009 at 4:10 pm

#1004327
RE: Are the posted questions getting worse?

WayneS (6/3/2009)
SQL Server Magazine just published an article by Itzik Ben-Gan where under certain conditions, a cursor-based approach scales out better than a set based one. I'm curious as 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)

June 3, 2009 at 3:40 pm

#1004319
RE: Are the posted questions getting worse?

john.arnott (6/3/2009)
bitbucket (6/3/2009)
RbarryYoung
The article link
http://www.sqlmag.com/Articles/ArticleID/101736/101736.html
but note:
This article is subscriber-only access
My goodness, what a teaser of an "Executive Summary" and first three sentences of the article. It sounds as...
--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)

June 3, 2009 at 3:33 pm

#1004315
RE: Convert string to human readable date/time format

n.heyen (6/3/2009)
Thank you Jeff for your input. When I run the example in SQL 2000, I don't get what I expected. It appears the offset is being subtracted from 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)

June 3, 2009 at 3:23 pm

#1004312
RE: Query for work shift differential

Absolutely. You can use CASE in just about any of the aggregate fuctions like SUM, etc.
--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)

June 2, 2009 at 9:47 pm

#1003746
RE: Are the posted questions getting worse?

Reviewing articles on this site would also mean reviewing the referenced articles from other sites. Then there're blogs and answers to posts. Where should the reviewing and censorship...
--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)

June 2, 2009 at 9:25 pm

#1003745
RE: The Sports Salary

Steve Jones - Editor (6/2/2009)
Jeff Moden (5/29/2009)
Nope... I don't want anyone to know how much more I make than them. 😉
Hey, if they saw your salary, along with your MVP,...
--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)

June 2, 2009 at 8:20 pm

#1003731
RE: Are the posted questions getting worse?

Dude... Lighten up. 😉
--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)

June 1, 2009 at 11:39 pm

#1003177
RE: Are the posted questions getting worse?

I was simply speaking what I felt in my heart
Heh... me too, Lynn... me too. 😉
--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)

June 1, 2009 at 10:07 pm

#1003148

Viewing 15 posts - 43,621 through 43,635 (of 59,097 total)