Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,811 through 15,825 (of 59,101 total)

RE: Are the posted questions getting worse?

BrainDonor - Friday, January 27, 2017 1:30 AM
Want...
Peeerrrfffeeccctttt! I'm gonna get me some. 😉 Then I'm going to have them 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)

January 27, 2017 at 8:46 am

#1925364
RE: Int vs Bigint

gvoshol 73146 - Friday, January 27, 2017 6:00 AM
At a previous job, I was looking at a table. "Wow, that's a lot...
--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)

January 27, 2017 at 8:23 am

#1925351
RE: Int vs Bigint

ZZartin - Thursday, January 26, 2017 10:19 AM
Thom A - Thursday, January 26, 2017 9:16 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)

January 27, 2017 at 8:15 am

#1925347
RE: Stored procedure takes more than minute to run.

If you want help on performance, please read and heed the article at the second link under "Helpful Links" in my signature line below.
--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)

January 27, 2017 at 7:58 am

#1925339
RE: The Elusive Conditional WHERE Clause

Hmmm... After reviewing the discussions, it seems that the flame wars have scared off a potentially good author since this is the only article he's published in 4 years.
--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)

January 27, 2017 at 7:53 am

#1925335
RE: Are the posted questions getting worse?

TomThomson - Thursday, January 26, 2017 8:40 PM
Jeff Moden - Thursday, January 26, 2017 6:41 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)

January 26, 2017 at 8:58 pm

#1925226
RE: Comma separated list

Alan.B - Wednesday, January 25, 2017 9:14 PM
Sergiy - Wednesday, January 25, 2017 3:32 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)

January 26, 2017 at 8:42 pm

#1925224
RE: Parent child hierarchy

PSB - Wednesday, January 25, 2017 4:54 PM
Jeff Moden - Wednesday, January 25, 2017 4:16 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)

January 26, 2017 at 7:13 pm

#1925220
RE: Are the posted questions getting worse?

TomThomson - Thursday, January 26, 2017 4:10 PM
GilaMonster - Thursday, January 26, 2017 2:49 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)

January 26, 2017 at 6:41 pm

#1925218
RE: Join Two CSV Files with a Common Column

corey lawson - Tuesday, January 24, 2017 11:03 PM
Jeff Moden - Tuesday, January 24, 2017 10:32 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)

January 25, 2017 at 4:38 pm

#1924986
RE: Parent child hierarchy

PSB - Wednesday, January 25, 2017 10:53 AM
Please help with the modifications to SuperTAskID null if parent . I 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)

January 25, 2017 at 4:16 pm

#1924985
RE: Parent child hierarchy

Jeff Moden - Wednesday, January 25, 2017 8:34 AM
Here's the solution you asked for. It also correctly places the "Handover Day". The...
--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)

January 25, 2017 at 9:54 am

#1924907
RE: Parent child hierarchy

Here's the solution you asked for. It also correctly places the "Handover Day". The correct solution would be to turn the table into a true Adjacency List for ease of...
--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)

January 25, 2017 at 8:34 am

#1924878
RE: Parent child hierarchy

PSB - Wednesday, January 25, 2017 5:14 AM
Can anyone please help ?
Yes. I'll be back in about 15 minutes. The problem with...
--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)

January 25, 2017 at 8:14 am

#1924867
RE: SSC Forum Updates

Dave Convery - Wednesday, January 25, 2017 6:46 AM
Brandie Tarvin - Wednesday,...
--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)

January 25, 2017 at 7:15 am

#1924845

Viewing 15 posts - 15,811 through 15,825 (of 59,101 total)