Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,406 through 12,420 (of 59,095 total)

RE: Number of Days between two Day Names

patrickmcginnis59 10839 - Saturday, May 5, 2018 11:23 AM
Jeff Moden - Saturday, May 5, 2018 8:35 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)

May 5, 2018 at 1:38 pm

#1989398
RE: To CASCADE DELETE or not?

My take on it is probably similar to yours. There are very few "NEVERs" in SQL Server.
I'd say that (as normal) "It Depends". For Cascade Deletes, it depends...
--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)

May 5, 2018 at 11:44 am

#1989395
RE: The Technology Journey to Disaster

I'm thinking that if you were a customer of the bank(s) involved, you might have a slightly different perspective. 😉
--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)

May 5, 2018 at 11:25 am

#1989394
RE: Date Upto 28 days ahead, no weekends

Eirikur Eiriksson - Saturday, May 5, 2018 3:47 AM
ringovski - Saturday, May 5, 2018 3:34 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)

May 5, 2018 at 11:24 am

#1989393
RE: Number of Days between two Day Names

patrickmcginnis59 10839 - Saturday, May 5, 2018 6:08 AM
Eirikur Eiriksson - Saturday, May 5, 2018 3:15 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)

May 5, 2018 at 8:35 am

#1989389
RE: Table Variable Parameters, Stored Procedures and Performance

pef - Friday, May 4, 2018 5:05 PM
Jeff Moden - Friday, May 4, 2018 4:07 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)

May 4, 2018 at 6:50 pm

#1989372
RE: Table Variable Parameters, Stored Procedures and Performance

pef - Friday, May 4, 2018 12:22 PM
Hi all, I have just started a new gig as a contractor, and the DB...
--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)

May 4, 2018 at 4:07 pm

#1989365
RE: How to find First monday of last month in SQL Help

Just in case you need to deal with dates prior to 1900-01-01 but no earlier that 1753-01-01... (-53690
--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)

May 4, 2018 at 3:43 pm

#1989363

RE: Number of Days between two Day Names

ScottPletcher - Friday, May 4, 2018 11:19 AM

Why the need to over-engineer everything? Each entry is, for example, "Wednesdays" not a specific...

--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)

May 4, 2018 at 3:00 pm

#1989356