Jeff Moden

Forum Replies Created

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

RE: Shrinking Transaction Log Files

Of course, I agree with all the info about having both a backup and restore plan and taking regular backups to support the RTO (Recovery Time Option) and RPO (Recovery Point...
--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)

November 27, 2017 at 5:35 pm

#1969636
RE: Start Fixing Your DB with Better Code

patrickmcginnis59 10839 - Monday, November 27, 2017 6:29 AM
On the "tower of babel" thing... no... it wasn't stupid. As you say, I'm...
--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)

November 27, 2017 at 10:35 am

#1969570
RE: Slow query - client or server issue

Grant Fritchey - Wednesday, November 22, 2017 9:12 AM
Jeff Moden - Wednesday, November 22, 2017 7:19 AM
--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)

November 27, 2017 at 6:26 am

#1969509
RE: Are the posted questions getting worse?

Ed Wagner - Monday, November 27, 2017 5:22 AM
Lynn Pettis - Saturday, November 25, 2017 12:13 PM
--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)

November 27, 2017 at 6:21 am

#1969507
RE: Help with code to Grouping the text in multiple lines

v.razaghzadeh - Sunday, November 26, 2017 7:24 AM
Hello everyone
I am a newcomer to the world of TSQL and was wondering if someone...
--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)

November 26, 2017 at 11:08 am

#1969457
RE: Start Fixing Your DB with Better Code

patrickmcginnis59 10839 - Saturday, November 25, 2017 2:30 PM
Jeff Moden - Saturday, November 25, 2017 11:32 AM
--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)

November 26, 2017 at 12:13 am

#1969447
RE: Start Fixing Your DB with Better Code

patrickmcginnis59 10839 - Saturday, November 25, 2017 1:18 PM
Jeff Moden - Saturday, November 25, 2017 11:32 AM
--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)

November 25, 2017 at 9:30 pm

#1969444
RE: Start Fixing Your DB with Better Code

patrickmcginnis59 10839 - Friday, November 24, 2017 10:42 AM
I get the sense that programming correctness isn't important to you and that...
--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)

November 25, 2017 at 11:32 am

#1969437
RE: Backing up multiple SQL instance and databases using 3rd party software - Any recommendations

Steve Jones - SSC Editor - Wednesday, November 22, 2017 4:36 PM
Jeff Moden - Wednesday, November 22,...
--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)

November 24, 2017 at 9:48 am

#1969411
RE: Start Fixing Your DB with Better Code

patrickmcginnis59 10839 - Friday, November 24, 2017 9:15 AM
Jeff Moden - Thursday, November 23, 2017 11:44 AM
--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)

November 24, 2017 at 9:28 am

#1969409
RE: Choosing the Birthday of a Customer by month?

ScottPletcher - Friday, November 24, 2017 8:02 AM
It makes zero sense to pull out just the month and index it. You'd 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)

November 24, 2017 at 9:13 am

#1969406
RE: Table Design

Jason A. Long - Thursday, November 23, 2017 10:32 PM
Iâ€™m not postponing a reply... Iâ€™m stupid drunk w/ fiends & family. Like...
--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)

November 23, 2017 at 11:14 pm

#1969373
RE: Table Design

Jason A. Long - Thursday, November 23, 2017 6:45 PM
Jeff,Iâ€™m on a phone at the moment so I wonâ€™t try to make...
--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)

November 23, 2017 at 9:06 pm

#1969369
RE: Are the posted questions getting worse?

Lynn Pettis - Wednesday, November 22, 2017 3:34 PM
Thom A - Wednesday, November 22, 2017 3:20 PM
--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)

November 23, 2017 at 11:54 am

#1969364
RE: Are the posted questions getting worse?

ThomasRushton - Thursday, November 23, 2017 1:49 AM
Lynn Pettis - Wednesday, November 22, 2017 1:37 PM
--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)

November 23, 2017 at 11:50 am

#1969363

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