Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,576 through 46,590 (of 59,095 total)

RE: Are the posted questions getting worse?

RBarryYoung (12/16/2008)
Jeff Moden (12/16/2008)
Steve Jones - Editor (12/16/2008)
you ought to be able to deal with a couple RBAR lovers!
Heh... yep... high velocity pork chops... bone in...:P
Hmm, maybe then we 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)

December 16, 2008 at 7:34 pm

#913532
RE: Not Displaying Records of one Date

Cool... thanks for the feedback.
--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)

December 16, 2008 at 7:28 pm

#913531
RE: The Full Potential of SQL 2000

Heh... Well said, Derek... I forget which year Bill Gates said it would happen, but he once said something to the effect that sometime in the very near future, there...
--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)

December 16, 2008 at 7:26 pm

#913530
RE: Guest Editorial: On writing SQL

Ed Salva (12/16/2008)
Jeff Moden (12/12/2008)
Heh... I've found that helical fletching makes a high velocity pork chop sound really cool as well as enhancing the flight path... haven't gotten into 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)

December 16, 2008 at 7:10 pm

#913527
RE: Are the posted questions getting worse?

Lynn Pettis (12/16/2008)
Well, looks like Jeff's twit logged on today, but I haven't heard squat regarding the code I provided. I guess the first pork chop Jeff gets 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)

December 16, 2008 at 6:43 pm

#913524
RE: Are the posted questions getting worse?

Steve Jones - Editor (12/16/2008)
you ought to be able to deal with a couple RBAR lovers!
Heh... yep... high velocity pork chops... bone in...:P
--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)

December 16, 2008 at 6:39 pm

#913522
RE: Redgate Backup Of "System" databases

Thanks, Perry... Heh... I've never used the RedGate software before... the learning curve isn't steep, but it's still a learning curve which was my reason for a bit of panic...
--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)

December 16, 2008 at 10:50 am

#913334
RE: Redgate Backup Of "System" databases

I'm afraid only Microsoft knows the answer to that question. I've set both databases back to simple and increased the frequency of the backups.
Thanks again for your help.
--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)

December 16, 2008 at 10:27 am

#913311
RE: Redgate Backup Of "System" databases

Well, by golly... I learn something new every day. I removed Master from the run and it still failed. I removed MSDB from the run and it worked...
--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)

December 16, 2008 at 10:17 am

#913299
RE: Redgate Backup Of "System" databases

george sibbald (12/16/2008)
Jeff, you cannot do a log backup of master even if you have set it to full recovery mode (why do you need that for master?)
I tried 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)

December 16, 2008 at 10:05 am

#913288
RE: Redgate Backup Of "System" databases

You bet... thanks, Perry...
Executed as user: dbUser. SQL Backup job failed with exitcode: 880 SQL error code: 911 [SQLSTATE 42000] (Error 50000). The step failed.
"dbUser" is a user...
--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)

December 16, 2008 at 10:01 am

#913279
RE: Are the posted questions getting worse?

Heh... maybe that's it... I've put up with stupid, rude, and arrogant people so long, since the kids have been gone I just don't have any room left for 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)

December 16, 2008 at 6:09 am

#913092
RE: Are the posted questions getting worse?

Grant Fritchey (12/16/2008)
I've officiated at karate matches. Some of the parents get truly obnoxious when little Timmy or Suzy get low scores or miss a point.
Did that too. 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)

December 16, 2008 at 6:05 am

#913090
RE: how to convert vb function to sql function

Understood and no problem.
Did you try my function, 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)

December 15, 2008 at 11:58 pm

#912956
RE: Are the posted questions getting worse?

rbarryyoung (12/15/2008)
Lynn Pettis (12/15/2008)
Jeff Moden (12/15/2008)
Just to be sure... you're a heck of a better man than me, Lynn... I looked at your posts and you were quite the gentleman...
--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)

December 15, 2008 at 10:09 pm

#912937

Viewing 15 posts - 46,576 through 46,590 (of 59,095 total)