Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,756 through 10,770 (of 59,099 total)

RE: Quitting Over Training

wodom - Wednesday, October 31, 2018 1:09 PM
This reminds me of a quote I heard. Someone on TV was interviewing a business...
--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 1, 2018 at 7:59 am

#2012046
RE: Max Time of Max day

Jason A. Long - Wednesday, October 31, 2018 5:30 PM
irehman - Wednesday, October 31, 2018 4:56 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)

October 31, 2018 at 6:49 pm

#2011988
RE: DT_BYTE to DT_DBDATE

jklenk86 - Wednesday, October 31, 2018 4:30 PM
Lynn Pettis - Wednesday, October 31, 2018 4:27 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)

October 31, 2018 at 6:47 pm

#2011987
RE: Create a scalar function (or not)

Can you post the code for the "TimelineMatch" function that you're calling from "inline"?
--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)

October 31, 2018 at 4:04 pm

#2011974
RE: DT_BYTE to DT_DBDATE

Please post a handful of the "0x" values from the table you loaded those DT_BYTE values into so we can have a look.
--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)

October 31, 2018 at 4:01 pm

#2011972
RE: Skills for Everyone in Tech

patrickmcginnis59 10839 - Wednesday, October 31, 2018 12:37 PM
Jeff Moden - Tuesday, October 30, 2018 8:38 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)

October 31, 2018 at 1:07 pm

#2011939
RE: Computed Column Specification formula

w.bartelink - Wednesday, October 31, 2018 12:28 PM
sgmunson - Wednesday, October 31, 2018 10: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)

October 31, 2018 at 12:59 pm

#2011938
RE: Exponential values conversion

Eirikur Eiriksson - Wednesday, October 31, 2018 8:01 AM
Jeff Moden - Wednesday, October 31, 2018 7: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)

October 31, 2018 at 8:03 am

#2011849
RE: Full Backup Files - Fastest Way to Copy Over WAN

dajonx - Wednesday, October 31, 2018 7:12 AM
Thank you for all of the responses!
We do have Riverbed CX5070 appliances at both sites. ...
--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)

October 31, 2018 at 7:50 am

#2011842
RE: Exponential values conversion

pwalter83 - Wednesday, October 31, 2018 5:15 AM
Eirikur Eiriksson - Wednesday, October 31, 2018 4: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)

October 31, 2018 at 6:25 am

#2011822
RE: Changing 1 or + in a telephone number to the correct format

saravanatn - Wednesday, October 31, 2018 1:34 AM
Jeff Moden - Monday, October 29, 2018 6:51 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)

October 31, 2018 at 6:09 am

#2011820
RE: seperate data in 1 row

Lynn Pettis - Tuesday, October 30, 2018 10:36 PM
Jeff Moden - Tuesday, October 30, 2018 6: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)

October 31, 2018 at 6:06 am

#2011819
RE: Full Backup Files - Fastest Way to Copy Over WAN

dajonx - Tuesday, October 30, 2018 9:28 AM
Hi,
I am trying to Robocopy large .bak files over the WAN and it's going terribly...
--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)

October 30, 2018 at 7:59 pm

#2011787
RE: seperate data in 1 row

Ya just gotta wonder if all those CASEd LIKEs are slower than just doing unconditional REPLACEs with the right collation.
p.s. Apparently the version of SQLPrompt you used doesn't...
--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)

October 30, 2018 at 6:20 pm

#2011784
RE: Skills for Everyone in Tech

drew.allen - Tuesday, October 30, 2018 8:08 AM
Jeff Moden - Tuesday, October 30, 2018 8:01 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)

October 30, 2018 at 8:38 am

#2011703

Viewing 15 posts - 10,756 through 10,770 (of 59,099 total)