Jeff Moden

Forum Replies Created

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

RE: SQL 2005 write performance

leonp (12/16/2008)
Gail, nothing significant .... I was just hoping someone took a look at my post and told me what they thought about my problem.
Thanks!
I'd be more interested 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 16, 2008 at 7:56 pm

#913543
RE: Are the posted questions getting worse?

... or not. Either way, it isn't gonna bug your friends.
--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:47 pm

#913539
RE: Are the posted questions getting worse?

Lynn Pettis (12/16/2008)
Was that good enough over there? I hate it when I click on a link in an email notification and it dies.
Heh... gotta think "pork chops", Lynn......
--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:46 pm

#913538
RE: Updating a Column Using a Recursive Definition

Sorry... been busy...
Were you able to flush out the anomoly?
--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:44 pm

#913537
RE: Redgate Backup Of "System" databases

Good link with good info. Thanks. I did do a full backup right after I changed the recovery mode to FULL... seems like the RedGate command line may...
--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:40 pm

#913534
RE: Are the posted questions getting worse?

Lynn Pettis (12/16/2008)
Well, I left him a message on that thread, and although the first one I wrote was nasty, I toned it down as this is a public site...
--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:37 pm

#913533
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

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