Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,251 through 14,265 (of 59,101 total)

RE: Are the posted questions getting worse?

Phil Parkin - Tuesday, September 26, 2017 11:56 AM
Jeff Moden - Tuesday, September 26, 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)

September 26, 2017 at 2:53 pm

#1961059
RE: Are the posted questions getting worse?

jonathan.crawford - Tuesday, September 26, 2017 10:30 AM
Luis Cazares - Tuesday, September 26, 2017 8:21 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)

September 26, 2017 at 11:44 am

#1961026
RE: Are the posted questions getting worse?

Jason A. Long - Saturday, September 23, 2017 5:31 PM
Entity Framework & LINQ...
recently talked to a company who is looking...
--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)

September 25, 2017 at 5:48 pm

#1960871
RE: Concatenate sp_MSForeachdb results

patrickmcginnis59 10839 - Monday, September 25, 2017 11:50 AM
Jeff Moden - Tuesday, September 19, 2017 6:10 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)

September 25, 2017 at 12:02 pm

#1960825
RE: Get the year and Qtr

Jason A. Long - Monday, September 25, 2017 10:42 AM
I've gotta go w/ Scott of this one... At some point, you...
--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)

September 25, 2017 at 11:42 am

#1960818
RE: Get the year and Qtr

ScottPletcher - Monday, September 25, 2017 9:53 AM
I suppose it's a matter of philosophy too. In my view, queries should not check...
--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)

September 25, 2017 at 11:38 am

#1960817
RE: Get the year and Qtr

ScottPletcher - Monday, September 25, 2017 8:14 AM
Jeff Moden - Saturday, September 23, 2017 8:24 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)

September 25, 2017 at 9:40 am

#1960783
RE: Get the year and Qtr

Ah... almost forgot. Neither Scott's nor mine checks to make sure the values of YYYY and MM are actually part of a valid date. Ostensibly, that's already been checked but...
--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)

September 23, 2017 at 8:24 pm

#1960630
RE: Get the year and Qtr

When I looked at the posted solutions, I was pretty sure that Scott's would be the fastest because of both not using CROSS APPLY and the Integer math he used. ...
--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)

September 23, 2017 at 8:07 pm

#1960629
RE: File with Datetime

Thom A - Friday, September 22, 2017 7:53 AM
This appears to be a duplicate of https://www.sqlservercentral.com/Forums/FindPost1898512.aspx
Agreed.... no posts here, please. ...
--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)

September 23, 2017 at 11:48 am

#1960621
RE: Substring

Thom A - Friday, September 22, 2017 7:59 AM
hoseam - Friday, September 22, 2017 7:22 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)

September 23, 2017 at 11:47 am

#1960620
RE: Setup the sync process against Large Database

Amit Kumar-481560 - Friday, September 22, 2017 11:31 AM
Jeff Moden - Wednesday, September 20, 2017 10:28 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)

September 22, 2017 at 11:40 pm

#1960612
RE: Get the year and Qtr

Luis Cazares - Friday, September 22, 2017 10:15 AM
Papil - Friday, September 22, 2017 9:48 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)

September 22, 2017 at 9:26 pm

#1960610
RE: Help from Cortana

I think the irony of it all is funny as hell. We can't get folks to make decent GUIs and yet we're going to trust a bot and voice recognition? ...
--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)

September 22, 2017 at 8:34 pm

#1960609
RE: Are the posted questions getting worse?

Michael L John - Friday, September 22, 2017 9:54 AM
Jeff Moden - Thursday, September 21, 2017 11:42...
--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)

September 22, 2017 at 7:24 pm

#1960606

Viewing 15 posts - 14,251 through 14,265 (of 59,101 total)