Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,191 through 14,205 (of 59,101 total)

RE: Date fun

Luis Cazares - Tuesday, October 3, 2017 6:47 AM
sipas - Tuesday, October 3, 2017 6:13 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)

October 3, 2017 at 10:36 am

#1962104
RE: Why SQL Server is Better Than Oracle

Eric M Russell - Tuesday, October 3, 2017 7:48 AM
I've worked with Oracle in the past as well, and I can adapt...
--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)

October 3, 2017 at 8:08 am

#1962073
RE: Since looping is bad, how should I accomplish what I am trying to do?

rmcfaden - Tuesday, October 3, 2017 7:21 AM
Jeff Moden - Tuesday, October 3, 2017 6:59 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)

October 3, 2017 at 7:39 am

#1962068
RE: Running balance calculation

sgmunson - Tuesday, October 3, 2017 6:44 AM
Jeff Moden - Monday, October 2, 2017 8: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)

October 3, 2017 at 7:29 am

#1962061
RE: Since looping is bad, how should I accomplish what I am trying to do?

Jason A. Long - Monday, October 2, 2017 9:09 PM
Jeff Moden - Monday, October 2, 2017 7:37...
--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)

October 3, 2017 at 6:59 am

#1962052
RE: Database maintenance

I think it to be a bit odd that you don't want to give the vendor temporary (and, hopefully) very limited privs to your system but you were entirely happy...
--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)

October 3, 2017 at 6:40 am

#1962044
RE: Date fun

Considering the correct answer, my question would be, what are the Use Cases behind doing such a thing?
--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)

October 3, 2017 at 6:33 am

#1962042
RE: Date fun

sipas - Tuesday, October 3, 2017 5:51 AM
American dates are weird.
Heh... and we're damned proud of it. 😉
--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)

October 3, 2017 at 6:32 am

#1962041
RE: Code-first vs database-first, any new developments?

Steve Jones - SSC Editor - Friday, September 29, 2017 9:47 AM
To be fair, plenty of people use tools (ErWin, Er/Studio, Visio,...
--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)

October 3, 2017 at 6:05 am

#1962033
RE: Why SQL Server is Better Than Oracle

Actually, having worked with both Oracle and SQL Server, I'll have to say that anyone that says one is better than the other is probably a bit out of line...
--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)

October 3, 2017 at 6:02 am

#1962031
RE: Running balance calculation

ChrisM@Work - Tuesday, October 3, 2017 2:05 AM
piet_dj - Monday, October 2, 2017 11: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)

October 3, 2017 at 5:52 am

#1962028
RE: The Worms-eye View

Phil Factor - Monday, October 2, 2017 10:49 AM
I agree that siloed thinking is bad, but so is a lack of understanding...
--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)

October 2, 2017 at 9:59 pm

#1961988
RE: Running balance calculation

piet_dj - Monday, October 2, 2017 10:42 AM
Yes I agree, the structure is not ideal (I can't change it), however an account...
--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)

October 2, 2017 at 9:51 pm

#1961986
RE: Running balance calculation

Damned forum software whacked the formatting on half the code. I tried to fix it but it's not buying it. Apologies there.
--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)

October 2, 2017 at 8:29 pm

#1961983
RE: Running balance calculation

sgmunson - Monday, October 2, 2017 12:46 PM
piet_dj - Monday, October 2, 2017 11:05 AM
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)

October 2, 2017 at 8:25 pm

#1961982

Viewing 15 posts - 14,191 through 14,205 (of 59,101 total)