Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,546 through 43,560 (of 59,101 total)

RE: Are the posted questions getting worse?

tosscrosby (6/8/2009)
Florian Reischl (6/8/2009)
Sometimes I'm feelin' like "Daddy Snarf" on this page...
Edit: Do you understand German?
I don't understand German. WTF does that mean?...goggle didn't help much! :w00t:
Bwaa-Haaa!!!! I think...
--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 8, 2009 at 12:28 pm

#1006249
RE: "Greek" data in my SQL table

Heh... just replace the names with NEWID().
--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 8, 2009 at 12:10 pm

#1006229
RE: CTE question

Greg,
One of the supposed advantages listed above for a CTE is if you have to reference the query it contains more than once. Let me say how dangerous 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 8, 2009 at 11:55 am

#1006217
RE: CTE question

Ramesh (5/29/2009)
The 3rd biggest thing is that you can write recursive queries using CTE.
... and kill yourself with hidden RBAR that rivals that of a 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)

June 8, 2009 at 11:53 am

#1006213
RE: buld a rule with Numeric chars only

Lowell,
The answer to your +- problem is that if you wish to include the dash in the pattern, it's easiest to do if you list it first so that it's...
--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 8, 2009 at 11:37 am

#1006203
RE: buld a rule with Numeric chars only

Carl Federl (6/8/2009)
Perhaps I am missing something, but what is wrong with the system function "isnumeric" ?
CREATE RULE [dbo].[NumericCharsOnly]
AS
ISNUMERIC(@value) = 1
GO
Here's one of many problems with ISNUMERIC...
--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 8, 2009 at 11:35 am

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

Heh... after reviewing the FAQ for StackOverflow, I have a couple of problems with that site... first, they want you to be both honest and nice. Most people interpret...
--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:28 pm

#1005899
RE: Sum of top n rows

Sergiy (6/7/2009)
Jeff Moden (6/6/2009)
Amazing... what the hell did the boys in Redmond do? The code posted above by arijit works just dandy in 2k5. The error appears when...
--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:11 pm

#1005897
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

Viewing 15 posts - 43,546 through 43,560 (of 59,101 total)