Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,756 through 13,770 (of 59,101 total)

RE: Tally Tables and Table Variables

Eirikur Eiriksson - Sunday, November 12, 2017 8:21 AM
Lesson for those who got this one wrong, AS in the column definition within...
--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 12, 2017 at 10:27 am

#1967689
RE: Odd behavior with views

I agree with Gail... While I absolutely agree that anecdotal evidence my identify the need, it should not be used to make a decision nor form the basis of some practice. ...
--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 12, 2017 at 10:25 am

#1967688
RE: Delete syntax not working

jcelko212 32090 - Saturday, November 11, 2017 1:29 PM
Jeff Moden - Sunday, November 5, 2017 7:25 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)

November 11, 2017 at 7:59 pm

#1967652
RE: Fill Factor

Arsh - Saturday, November 11, 2017 5:23 AM
For more clarity on this point , when a new row is inserted ,...
--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 11, 2017 at 2:03 pm

#1967648
RE: Fill Factor

Grant Fritchey - Friday, November 10, 2017 12:26 PM
Jeff Moden - Friday, November 10, 2017 12:21 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)

November 10, 2017 at 7:30 pm

#1967622
RE: Should We Move to Azure?

xsevensinzx - Thursday, November 9, 2017 11:11 PM
Jeff Moden - Thursday, November 9, 2017 6:30 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)

November 10, 2017 at 6:47 pm

#1967620
RE: Are the posted questions getting worse?

Brandie Tarvin - Friday, November 10, 2017 5:49 AM
Sean Lange - Thursday, November 9, 2017 2:42 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)

November 10, 2017 at 5:52 pm

#1967618
RE: Does Anyone know how you can copy values from a previous row into a null column in SSIS

aaron.reese - Friday, November 10, 2017 2:30 PM
Don't know why but that picture reminds me of the story of the RAF testing...
--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 10, 2017 at 5:32 pm

#1967616
RE: Fill Factor

Arsh - Friday, November 10, 2017 7:56 AM
John Mitchell-245523 - Friday, November 10, 2017 7:12 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)

November 10, 2017 at 12:21 pm

#1967570
RE: Tally Tables and Table Variables

p.s. Cool problem, BTW.
--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 10, 2017 at 12:11 pm

#1967567
RE: Tally Tables and Table Variables

What truly amazes me is the number of people that selected either of the first 2 answers. I can understand how someone might make the mistake of the last one...
--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 10, 2017 at 12:10 pm

#1967566
RE: TransactionLog. VLF Fragmentation.

dmbsseller - Thursday, November 9, 2017 10:58 PM
Jeff Moden - Thursday, November 9, 2017 8:45 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)

November 10, 2017 at 11:58 am

#1967565
RE: TransactionLog. VLF Fragmentation.

John Mitchell-245523 - Friday, November 10, 2017 1:10 AM
dmbsseller - Thursday, November 9, 2017 10:58 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)

November 10, 2017 at 11:55 am

#1967564
RE: How Long Before You Upgrade?

jkolstad - Friday, November 10, 2017 6:13 AM
After spending 6 months justifying upgrades to management we finally received approval to upgrade SQL...
--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 10, 2017 at 9:17 am

#1967545
RE: Trying to speed up this 'GetWorkingDays' function.

Awesome. I bloody well missed the Implicit Conversion problem, Chris. :blush::blush::blush: Thanks for the follow up, the function modification, and the retesting, Chris.
Now... let's all...
--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 10, 2017 at 6:46 am

#1967514

Viewing 15 posts - 13,756 through 13,770 (of 59,101 total)