Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,331 through 42,345 (of 59,067 total)

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
RE: There's a Lot to Learn From Even Simple Puzzles

Phil had mentioned something about the documentation in my code... It's nothing compared to the absolutely incredible documentation that some others included in their code. For example, you could...
--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:43 pm

#1037797

Viewing 15 posts - 42,331 through 42,345 (of 59,067 total)