Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,366 through 43,380 (of 59,063 total)

RE: Are the posted questions getting worse?

RBarryYoung (6/14/2009)
Grant Fritchey (6/14/2009)
Jeff Moden (6/14/2009)
Grant Fritchey (6/14/2009)
I've got a spotlight and an alternate in the regular sessions.
"Regular Sessions"? Are you talking about "general" sessions? I've not received...
--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 15, 2009 at 10:33 am

#1009763
RE: Are the posted questions getting worse?

Paul White (6/14/2009)
Alvin Ramard (6/14/2009)
Paul White (6/14/2009)
RBarryYoung (6/14/2009)
What shall we name it? 😛
Troll Name Generator
I sure won't use that tool for a troll name!!
😎
For those too busy 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)

June 15, 2009 at 10:29 am

#1009761
RE: Append output from SQLCMD in batch file

carissa.chris (6/15/2009)
I wanted a "forever" log and the ">> E:\output.txt" accomplishes exactly what I needed. Thanks for all the input.
🙂
Ok... you guys can remove the handrails, now. ...
--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 15, 2009 at 10:08 am

#1009750
RE: Append output from SQLCMD in batch file

Thanks for the feedback Carissa.
--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 15, 2009 at 10:07 am

#1009749
RE: Which Rows in Cursor?

Heh... Flo is correct... certain administrative code certainly justifies the use of Cursors and/or While Loops. I'm not so sure that Ken's application requires it because I simply don't...
--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 15, 2009 at 10:01 am

#1009745
RE: DBA job not busy enough

Search the dbo.sysComments tables (SQL Server 2000) or the sys.sql_modules tables (SQL Server 2005) for the word "WHILE" and repair that code.
Also, test the restoration of backups and maybe write...
--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 14, 2009 at 4:28 pm

#1009406
RE: Grouping problem

Tim Hobbs (6/14/2009)
Mark's original answer sorted my problem in no time at all; so thanks for that. I'm familiar with ROW_NUMBER but hadn't thought of using it in this...
--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 14, 2009 at 3:53 pm

#1009402
RE: Append output from SQLCMD in batch file

matt stockham (6/14/2009)
Jeff Moden (6/14/2009)
Understood. My point is that I wasn't sure if the OP was going for a continuous "forever" log or just wanted a single log with...
--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 14, 2009 at 3:51 pm

#1009400
RE: Test your problem solving skills!

talltop (6/14/2009)
As you traverse your DBA career, you will run into situations that are not always by the book.
Heh... understood. And I understand the premise that you walked...
--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 14, 2009 at 3:46 pm

#1009398
RE: Inserted records with a subsequence number

Yes. Of course, you can change that. I don't believe the method that Lowell posted is dependent on what the primary key actually is.
--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 14, 2009 at 11:42 am

#1009342
RE: Are the posted questions getting worse?

Grant Fritchey (6/14/2009)
I've got a spotlight and an alternate in the regular sessions.
"Regular Sessions"? Are you talking about "general" sessions? I've not received anything one way or 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)

June 14, 2009 at 11:18 am

#1009332
RE: Append output from SQLCMD in batch file

WayneS (6/14/2009)
Jeff Moden (6/14/2009)
You've added a line of code the OP didn't have in the original problem and that new line is the one responsible for the incorrect operation.
echo %date%...
--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 14, 2009 at 10:59 am

#1009331
RE: Grouping problem

RBarryYoung (6/14/2009)
I guess almost everybody knows this trick by now?
Heh... apparently not. The OP didn't and neither did the 30 or so DBA's/Developers that I gave a couple 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)

June 14, 2009 at 10:54 am

#1009328
RE: Are the posted questions getting worse?

GilaMonster (6/14/2009)
Encountering that kinda attitude either in posts, PMs or emails makes me stop and ask myself why the hell I'm doing the forum thing in the first place.
Heh... you'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 14, 2009 at 10:45 am

#1009326
RE: Are the posted questions getting worse?

Steve Jones - Editor (6/14/2009)
I have removed the account of our (un)professional1 friend from the system and deleted threads. Apologies to those of you that had to deal with him/her....
--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 14, 2009 at 9:50 am

#1009314

Viewing 15 posts - 43,366 through 43,380 (of 59,063 total)