Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,311 through 14,325 (of 59,097 total)

RE: The struggle to renormalize data

Ed Wagner - Thursday, September 14, 2017 9:13 PM
Jeff Moden - Thursday, September 14, 2017 5:38 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)

September 14, 2017 at 10:35 pm

#1959535
RE: Are the posted questions getting worse?

Jeff Moden - Thursday, September 14, 2017 7:39 PM
Jeff Moden - Thursday, September 14, 2017 7:37 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)

September 14, 2017 at 9:10 pm

#1959533
RE: Are the posted questions getting worse?

Jeff Moden - Thursday, September 14, 2017 7:37 PM
Steve Jones - SSC Editor - Thursday, September 14,...
--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)

September 14, 2017 at 7:39 pm

#1959529
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Thursday, September 14, 2017 7:06 PM
Jeff Moden - Thursday, September 14,...
--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)

September 14, 2017 at 7:37 pm

#1959528
RE: Determining Memory Pressure

GilaMonster - Thursday, September 14, 2017 12:09 PM
Jeff Moden - Thursday, September 14, 2017 6:52 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)

September 14, 2017 at 5:42 pm

#1959522
RE: The struggle to renormalize data

ManicStar - Thursday, September 14, 2017 11:28 AM
I loathe json... don't see the point of it over XML or even flat files.
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)

September 14, 2017 at 5:38 pm

#1959521
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Thursday, September 14, 2017 2:15 PM
Lynn Pettis - Thursday, September 14,...
--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)

September 14, 2017 at 5:36 pm

#1959520
RE: Date Causing Problem

ScottPletcher - Thursday, September 14, 2017 3:31 PM
As an aside, I suggest you use >= and < for all date/time/datetime comparisons rather...
--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)

September 14, 2017 at 5:33 pm

#1959519
RE: Forum Etiquette: How to post data/code on a forum to get the best help

drew.allen - Thursday, September 14, 2017 7:44 AM
stanteitelbaum - Thursday, September 14, 2017 6:05 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)

September 14, 2017 at 8:12 am

#1959441
RE: New company use c# code instead of SSIS

Given my own lead, I'd avoid both methods and do it all in T-SQL but the C# method doesn't sound bad. I just like to avoid compiled code for such...
--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)

September 14, 2017 at 7:17 am

#1959418
RE: Date Causing Problem

r5d4 - Thursday, September 14, 2017 4:08 AM
Ah, I thought I'd avoided Sargability by not manipulating my date column, only the GETDATE()...
--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)

September 14, 2017 at 7:15 am

#1959417
RE: Determining Memory Pressure

Arsh - Thursday, September 14, 2017 2:44 AM
GilaMonster - Wednesday, September 13, 2017 11:28 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)

September 14, 2017 at 6:52 am

#1959411
RE: Running total with reset condition

Steve Jones - SSC Editor - Wednesday, September 13, 2017 8:37 AM
Please mark Jeff's answer as correct, if you wouldn't mind.
Thank you...
--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)

September 13, 2017 at 4:48 pm

#1959351
RE: SQL 2012 file processing from Access

I'm thinking the ACE drivers might let you do such a thing directly.
--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)

September 13, 2017 at 4:44 pm

#1959350
RE: Determining Memory Pressure

GilaMonster - Wednesday, September 13, 2017 11:28 AM
Jeff Moden - Wednesday, September 13, 2017 6:33 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)

September 13, 2017 at 1:24 pm

#1959324

Viewing 15 posts - 14,311 through 14,325 (of 59,097 total)