Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,841 through 39,855 (of 59,072 total)

RE: Calculating Work Days

Jeff Moden (2/5/2010)
I saw a tight little forumula for this about a year ago... I'm not sure where I put it but I'll try to find it this weekend.
Ah... 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)

February 8, 2010 at 7:14 pm

#1115888
RE: store output of stored proc into temp table

Very cool, my old friend. I'll take a look at it. Thank you for spending the time 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)

February 8, 2010 at 12:21 pm

#1115729
RE: Cannot Get Average of rowcount: Msg 130, Level 15, State 1, Line 1 Cannot perform an aggregate function on an expression

Thanks for the feedback, 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)

February 8, 2010 at 11:59 am

#1115711
RE: Are the posted questions getting worse?

Alvin Ramard (2/6/2010)
CirquedeSQLeil (2/6/2010)
Alvin Ramard (2/6/2010)
Well, at least we don't have to worry that someone will mess up their database by running the command.
Don't be too sure about that (evil...
--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)

February 7, 2010 at 9:39 pm

#1115281
RE: DBCC Timewarp

CirquedeSQLeil (2/7/2010)
\This is where the optional parameters come into play.
Use the optional parameters to prevent the mindwarp and invoke a mindmeld. The mindmeld helps will either help you understand...
--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)

February 7, 2010 at 9:24 pm

#1115280
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

Jeff Moden (2/4/2010)
Hugo Kornelis (2/4/2010)
Hi Jeff,
As indicated in my previous message, I somehow lost sight of this discussion. Sorry for my sudden disappearance from this topic.
First, thank you for optimizing...
--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)

February 7, 2010 at 9:19 am

#1115194
RE: Stored Procedure

My recommendation would be to put the rows to be tested for insert into a temp table with an extra "Flag" (TINYINT) column. Do a joined update between 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)

February 7, 2010 at 8:48 am

#1115191
RE: Extract X and Y coordinates out of a string and check if within range

Awesome. Thanks for the feedback, Charlotte.
--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)

February 7, 2010 at 7:21 am

#1115181
RE: DBCC Timewarp

george sibbald (2/7/2010)
Bob, if you use the same racks and don't get all 137 parameters absolutely correct you run the risk of melding the new servers to the old servers....
--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)

February 7, 2010 at 6:23 am

#1115177
RE: Distributed Transaction?

BSavoie (2/6/2010)
Thanks Jeff. actually, I've been doing a little research, I might be better off using SSIS here. I think I understand how to get the service state using SSIS/WMI,...
--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)

February 7, 2010 at 6:17 am

#1115176
RE: Best Practice : coalesce vs. isnull?

Paul White (2/7/2010)
I could argue that NULL is in fact evil, but I suspect that might start a whole new debate 😀
BWAA-HAAA! NULL is not nothing to argue about....
--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)

February 7, 2010 at 6:14 am

#1115175
RE: Today's Random Word!

satirical
--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)

February 6, 2010 at 10:13 pm

#1115149
RE: I'm from the government and I'm here to help

Wait just a minute! "It Depends"! You might just be able to get away with it if you set parameter 136 of DBCC TIMEWARP to a negative decimal...
--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)

February 6, 2010 at 10:01 pm

#1115147
RE: Query to ignore common records

Use a FULL OUTER JOIN. If you don't know how to use it, now's the time to get inline with Books Online. 🙂
--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)

February 6, 2010 at 9:57 pm

#1115146
RE: Best Practice : coalesce vs. isnull?

GSquared (12/14/2009)
BaldingLoopMan (12/14/2009)
actually u can use isnull in all situations if u wanted to. A coalesce is a nested isnull.
coalesce(custname, last, first) = isnull( isnull( custname, last ), first...
--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)

February 6, 2010 at 9:53 pm

#1115145

Viewing 15 posts - 39,841 through 39,855 (of 59,072 total)