Jeff Moden

Forum Replies Created

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

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
RE: Get-DbaPowerShell

Steve Jones - SSC Editor - Monday, October 2, 2017 10:49 AM
kevin77 - Monday, October 2, 2017...
--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:03 pm

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

Cool. I'm thinking that we can simplify a bit. Using one of the code pieces that you posted from the collective thoughts of the people on this thread, we can...
--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 7:37 pm

#1961980
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

david.leyden - Sunday, October 1, 2017 11:16 PM
I've come across this article and a few others that suggest it is a limitation...
--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 6:00 pm

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

rmcfaden - Monday, October 2, 2017 4:42 PM
Jeff Moden - Monday, October 2, 2017 8: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 2, 2017 at 4:51 pm

#1961973
RE: sa password fault - Possibly OK after restart

as1981 - Monday, October 2, 2017 2:33 PM
Hello,
Sorry, that wasn't intentional. I hadn't seen previous advice to disable SA so hadn't done...
--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 4:38 pm

#1961970
RE: Are the posted questions getting worse?

jasona.work - Monday, October 2, 2017 1:22 PM
jonathan.crawford - Monday, October 2, 2017 12: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)

October 2, 2017 at 2:27 pm

#1961955

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