Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,361 through 42,375 (of 59,098 total)

RE: WORD UP!

No problem... thanks for taking the time to repost. It's another avenue I can check. 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)

August 12, 2009 at 12:01 pm

#1038186
RE: SQLServerCentral Editorial Policy - Article Publication

Tim Walker (8/12/2009)
I'm not sure how you got the fact that I give the author 'credit' from what I wrote.
Perhaps expanding what I quoted previously...
Finally what I didn't like 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)

August 12, 2009 at 11:38 am

#1038171
RE: Using CURSOR

Gianluca Sartori (8/12/2009)
Shyamala Shankar Raman (8/12/2009)
Instead u can use while loop.. which will solve the problem
Sure it will, you would only have to wait longer.
While loops are no better than...
--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)

August 12, 2009 at 6:54 am

#1037962
RE: WORD UP!

I'll take a look at that. Thanks guys.
--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)

August 12, 2009 at 6:45 am

#1037955
RE: SQLServerCentral Editorial Policy - Article Publication

Tim Walker (8/12/2009)
...was submitted in good faith and after some effort to write it...
I didn't see much of either in that article. I can understand why people were so...
--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)

August 12, 2009 at 6:38 am

#1037947
RE: bulk logged insertion

Just because a DB is in the bulk logged recovery mode, doesn't mean that the simple use of either BCP or BULK INSERT will meet the requirements of a bulk...
--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)

August 11, 2009 at 10:57 pm

#1037844
RE: String or binary data would be truncated

BWAA-HAA!!! Now where would the fun in that be. 😀
--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)

August 11, 2009 at 10:52 pm

#1037842
RE: unwanted Order By side effect

Heh... ALL code is production code... maybe just not yet. 😉
--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)

August 11, 2009 at 10:47 pm

#1037841
RE: Script Task to Configure FTP Connection

Dang... I'm doing a whole lot with FTP right now. The thing is, I don't know how to help you because I'm doing it all through .bat files controlled...
--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)

August 11, 2009 at 10:44 pm

#1037840
RE: There's a Lot to Learn From Even Simple Puzzles

...makes me loquacious
I believe they have a vaccine for that now... keeps mosquito's from landing on you, 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)

August 11, 2009 at 10:40 pm

#1037838
RE: Jr. DBA

cstewart (8/11/2009)
Ultimately, I suppose I'll just have to throw a bunch of resumes against the wall and see what sticks.
That's not exactly the advice that was given nor the attitude...
--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)

August 11, 2009 at 10:20 pm

#1037832
RE: SQL w/ MAX function does not work

Matt Miller (8/11/2009)
Did I miss the part which explains what doesn't work? Sorry if I'm being dense- I just don't get a good understanding of what is not happening....
--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)

August 11, 2009 at 10:18 pm

#1037830
RE: SQLServerCentral Editorial Policy - Article Publication

Steve Jones - Editor (8/11/2009)
In terms of deciding what should be published, I'm concerned someone writing about transaction logs might get shut down. Volunteers would say (for example) that Gail...
--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)

August 11, 2009 at 10:14 pm

#1037828
RE: SQLServerCentral Editorial Policy - Article Publication

Fal (8/11/2009)
My thoughts on a workable solution would be to have a “Pending Articles” page or similar, where volunteer reviewers could post comments. Those could be the basis of...
--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)

August 11, 2009 at 10:06 pm

#1037825
RE: Using a subquery in select list with a GROUP BY clause?

pwatson (8/10/2009)
Hi, thanks for the response. I managerd to sort my problem out by using a view instead. The code's a bit convoluted so I think it's best...
--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)

August 11, 2009 at 6:55 pm

#1037798

Viewing 15 posts - 42,361 through 42,375 (of 59,098 total)