Jeff Moden

Forum Replies Created

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

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
RE: Start Fixing Your DB with Better Code

seo.reputeinfosystems - Thursday, November 23, 2017 12:01 AM
I am currently working on a monitoring tool where the database "architecture" was...
--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:45 am

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

Sergiy - Thursday, November 23, 2017 1:45 AM
Jeff Moden - Tuesday, November 21, 2017 8:46 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 10:51 am

#1969359
RE: Better TSQL Performance

Lynn Pettis - Wednesday, November 22, 2017 3:55 PM
Jeff Moden - Wednesday, November 22, 2017 3:50 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 10:44 am

#1969357
RE: Table Design

Jason A. Long - Wednesday, November 22, 2017 3:57 PM
Grant Fritchey - Wednesday, November 22, 2017 9:57...
--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:20 am

#1969355
RE: Better TSQL Performance

drew.allen - Wednesday, November 22, 2017 8:25 AM
Jeff Moden - Wednesday, November 22, 2017 8:20 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 22, 2017 at 3:50 pm

#1969291
RE: Table Design

Remember or discover that the Clustered Index can have more than one use (didn't say more than one key) and is not necessarily the panacea of performance that people would sometimes...
--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 22, 2017 at 3:48 pm

#1969290

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