Jeff Moden

Forum Replies Created

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

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
RE: SSC Forum Updates

Jeff Moden - Tuesday, January 24, 2017 10:01 AM
damon.witherick - Monday, January 23, 2017 12: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)

January 24, 2017 at 10:37 pm

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

Just a note to anyone that may be watching... I think it's a mortal sin to install MS Office on the same "box" that SQL Server lives on.
--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 24, 2017 at 10:32 pm

#1924783
RE: SSC Forum Updates

damon.witherick - Monday, January 23, 2017 12:44 AM
Hi Jeff,
Do you mind me asking what browser (and version) you're using please.
Thanks
Damon
Ah, sorry. ...
--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 24, 2017 at 10:01 am

#1924668

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