Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,516 through 43,530 (of 59,063 total)

RE: Generating records without using cursor

lmu92 (6/7/2009)
I was wondering about his reply too, since the two statements (regarding the article and the correlation to the original subject) within one post don't seem to match 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 7, 2009 at 9:01 pm

#1005896
RE: Generating records without using cursor

RBarryYoung (6/7/2009)
Jeff Moden (6/7/2009)
Indu (6/7/2009)
I have gone through the example
Heh... is it just me or does that really sound pompous and arrogant? 😉
No, i wouldn't say that it was pompous...
--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 7, 2009 at 8:43 pm

#1005894
RE: QueryTo Get All Scripts

Do a search for the old ScptXfr.exe code that used to come with SQL Server 2000. Rumor has it that it works well with SQL Server 2005 but I've...
--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 7, 2009 at 8:38 pm

#1005893
RE: Dates Between From date and To Date

Well done one and all, but there is no need for such complex solutions.
INSERT INTO dbo.tbl_Destination
(EmpNo, TheDate, Project)
SELECT s.EmpNo, DATEADD(dd,...
--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 7, 2009 at 3:26 pm

#1005870
RE: Generating records without using cursor

Indu (6/7/2009)
I have gone through the example
Heh... is it just me or does that really sound pompous and arrogant? 😉
--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 7, 2009 at 3:02 pm

#1005867
RE: need help -- tempdb full message, but its only 8 mb in size

Mike (6/7/2009)
the db is set to unrestricted growth and has been, so that's not it.
Stupid question, then. Are you sure you're looking at the correct server? TempDB...
--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 7, 2009 at 2:55 pm

#1005863
RE: What SQL Server Sites do you use?

Doc (6/7/2009)
Lynn Pettis (6/5/2009)
I am curious, which sites do you use or frequent either asking for help or helping others?
I don't use them, I'm just regularly visit them all, forums...
--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 7, 2009 at 12:55 pm

#1005852
RE: sql server error

Brainy,
Gail's answer is the method I use if I have to do something like this (rare, usually wrong thing to do, but sometimes similar thing correctly happens on maintenance scripts)....
--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 7, 2009 at 12:40 pm

#1005850
RE: charindex help

Thanks for the awesome feedback, John. I really appreciate it.
Thanks for including an explanation, as well. I normally try to explain the code for the OP in 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 6, 2009 at 6:44 pm

#1005762
RE: Are the posted questions getting worse?

David Burrows (6/6/2009)
But more time for the deflected rebound to smack you in the face 😛
BWAA-HAA!!! There in lies the secret... you have to learn how to catch them...
--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 6, 2009 at 4:29 pm

#1005761
RE: Are the posted questions getting worse?

Yep... found it that way in 2k5, as well, just like Paul said. As Gail pointed out, they still haven't said anything explicit about using a table alias 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 6, 2009 at 1:50 pm

#1005756
RE: What SQL Server Sites do you use?

Lynn Pettis (6/6/2009)
Jeff Moden (6/5/2009)
99.99% SQLServerCentral.com - I like folks like you and the others I've come to know and some of the other sites just seem to bloody rude...
--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 6, 2009 at 1:42 pm

#1005755
RE: Are the posted questions getting worse?

GilaMonster (6/6/2009)
Jeff Moden (6/6/2009)
Gail's BOL link doesn't work for me when I paste it into the help URL field. I'm still using 2k5 if that matters.
It does matter. 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)

June 6, 2009 at 1:25 pm

#1005754
RE: Are the posted questions getting worse?

Paul White (6/6/2009)
BTW on behalf of Cancerians everywhere, what's all this with the crabbin'??? 🙂
BWAA-HAA! It's just me trying to get used to the kinder words so 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)

June 6, 2009 at 1:17 pm

#1005752
RE: Are the posted questions getting worse?

Paul White (6/6/2009)
I deliberately said 'not well documented' because I had seen it in BOL - see Gail's post for the link. It's just in totally the wrong place,...
--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 6, 2009 at 9:15 am

#1005726

Viewing 15 posts - 43,516 through 43,530 (of 59,063 total)