Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,591 through 46,605 (of 59,101 total)

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
RE: how to convert vb function to sql function

I don't agree with returning a 0.00 for an invalid fraction, but it's not my code nor requirements. Replace the following section of code in my code and 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 15, 2008 at 10:02 pm

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

Jedi Master (12/15/2008)
Here's my final (?) function... Do you see any ways to improve it? It takes all sorts of inputs into consideration, even if you enter "a1/2"...
Simple test says...
--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 9:50 pm

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

Jedi Master (12/15/2008)
Here's my final (?) function... Do you see any ways to improve it? It takes all sorts of inputs into consideration, even if you enter "a1/2"...
Thought you didn'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)

December 15, 2008 at 9:44 pm

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

Thanks for the feedback... the question now is do you really need the individual pieces?
--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 9:42 pm

#912927
RE: Are the posted questions getting worse?

Soooooo.... no pooping... no walking away... don'cha ever get constipated? 😛
--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 9:38 pm

#912925
RE: Are the posted questions getting worse?

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 in...
--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 9:30 pm

#912922
RE: Guest Editorial: On writing SQL

Not ever, it sounds like. Well done.
--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 9:22 pm

#912917
RE: Are the posted questions getting worse?

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 in explaining the facts 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)

December 15, 2008 at 9:19 pm

#912915
RE: How do you archive data?

Oh yeah... almost forgot... plan for it now... if you leave the long term archive as daily tables, you'll have a hell of a time doing a search for a...
--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 9:11 pm

#912913

Viewing 15 posts - 46,591 through 46,605 (of 59,101 total)