Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,316 through 36,330 (of 59,102 total)

RE: replacing long running cursor

Ah... my apologies. I didn't look to see that this is for an SQL Server 2000 instance.
Unless WayneS or someone else beats me to it (which I don't mind...
--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)

October 22, 2010 at 7:15 am

#1240884
RE: replacing long running cursor

Sanjay-940444 (10/20/2010)
I have one question here
Does SQL Server guarantee that update will be done strictly in top down manner?
I didnt find it writtem anywhere in BOL.
Actually, like anything else, it...
--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)

October 22, 2010 at 7:03 am

#1240881
RE: fn_getfiledetails - a replacement for xp_getfiledetails

SQLKnight (6/17/2010)
I agree with the SSC Rookie's post. sp_OAGetProperty is very soon to get deprecated. We shall replace such codes with CLR functions.
Thanks for the article though.
Heh... Microsoft continues 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)

October 22, 2010 at 6:54 am

#1240872
RE: which cmd or function can transfer printed message to a sql file?

lvzheng (10/22/2010)
then how can i get them from Windows Event Viewer?
xp_readerrorlog. See the following article for a bit more information...
http://www.sqlteam.com/article/using-xp_readerrorlog-in-sql-server-2005
BUT, now that you've said that, WHY do you feel...
--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)

October 22, 2010 at 6:50 am

#1240868
RE: SPLIT TSQL Between two character

WayneS (10/21/2010)
Craig Farrell (10/21/2010)
Here's the DelimitedString8k function that's been heavily worked on round these parts. Modify to suit your needs. I didn't create it, didn't work on it,...
--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)

October 21, 2010 at 11:35 pm

#1240721
RE: Sequence-numbering groups

gmrose (10/21/2010)
Thank you again to Lutz and Wayne. I updated my script per Lutz' suggestions to use table #tmpChecks instead of table variable @tmpChecks. I made some minor...
--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)

October 21, 2010 at 11:29 pm

#1240719
RE: which cmd or function can transfer printed message to a sql file?

You can always raise an error to the SQL log file.
--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)

October 21, 2010 at 10:34 pm

#1240707
RE: Are the posted questions getting worse?

WayneS (10/21/2010)
Did you ever post about this? Counting you and me, there's only about, well, 2 people that know what you're talking about here.
Nope... that's going to be 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)

October 21, 2010 at 10:23 pm

#1240704
RE: Large Chunks of Data

Steve Jones - SSC Editor (9/20/2010)
Eric Russell 13013 (9/20/2010)
Whenever someone requests the creation of a new report, and the specifications don't seem clear or feasible (for example 50 columns fit...
--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)

October 21, 2010 at 9:30 pm

#1240698
RE: Else '' Returns a 0?

CELKO (10/20/2010)
In 25 words or less it is "Logical versus Physical", but it goes beyond that. If you do not have a good conceptual model, you hit a ceiling 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)

October 21, 2010 at 9:23 pm

#1240695
RE: Else '' Returns a 0?

Kit G (10/20/2010)
CELKO (10/20/2010)
...
Columns hold values, not values or formulas.
Ah, the vagueness of the English language... I don't quite understand your last sentence, Joe.
Are you saying that columns can hold...
--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)

October 21, 2010 at 9:22 pm

#1240694
RE: Else '' Returns a 0?

Kit G (10/20/2010)
Hope I didn't step on your toes, Jeff. 😀
Nope... you did just fine and your great explanation is where I was going with it all. Very well...
--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)

October 21, 2010 at 9:18 pm

#1240692
RE: Cumulative sum for multiple sequences

I guess I'd have to be there to look at the whole thing. I'm out of "remote" ideas on the problem. My apologies.
--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)

October 21, 2010 at 9:09 pm

#1240689
RE: Best code for generating sequence numbers

ta.bu.shi.da.yu (10/21/2010)
Jeff Moden (10/21/2010)
ta.bu.shi.da.yu (10/21/2010)
Jeff Moden (2/6/2010)
Here's the code that my old DBA and I came up with. The day we replaced the original code with the following code,...
--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)

October 21, 2010 at 9:02 pm

#1240688
RE: Are the posted questions getting worse?

Paul White NZ (10/19/2010)
Jeff Moden (10/19/2010)
I prefer your simplified row number checker. It doesn't slow down much and doesn't have problems with unbalanced sets that Hugo's code does.
Thanks. ...
--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)

October 21, 2010 at 8:52 pm

#1240687

Viewing 15 posts - 36,316 through 36,330 (of 59,102 total)