Jeff Moden

Forum Replies Created

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

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
RE: Are the posted questions getting worse?

Speaking of stupid people, my Debbie stopped at the store on the way home for a couple of things. There was no bottled water, no bread, and a lot 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)

November 9, 2017 at 7:05 pm

#1967479
RE: Should We Move to Azure?

xsevensinzx - Thursday, November 9, 2017 3:31 PM
Jeff Moden - Thursday, November 9, 2017 8:26 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 9, 2017 at 6:30 pm

#1967478
RE: Importing Variable length text files into SQL

steve.alston - Thursday, November 9, 2017 5:51 PM
Thanks to everyone who helped me.
brad.mason 's answer works great. I don't know why I...
--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 9, 2017 at 6:24 pm

#1967477
RE: Using Extended Events to alert on long running queries

Anchelin - Thursday, November 9, 2017 8:23 AM
Hi
Is there a way with Extended Events, where I can set up something; should a...
--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 9, 2017 at 2:39 pm

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

sgmunson - Thursday, November 9, 2017 1:22 PM
Not that a high velocity pork-chop wouldn't cause any pain, but it would have...
--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 9, 2017 at 1:42 pm

#1967456
RE: Name Value Pairs Table Handling

jcboyer-1091017 - Thursday, November 9, 2017 12:03 AM
Matt Miller (4) - Wednesday, November 8, 2017 6:59 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 9, 2017 at 9:02 am

#1967410

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