Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,891 through 10,905 (of 59,099 total)

RE: Using your critical eye to see something positive

Jason- - Thursday, October 18, 2018 6:46 AM
Jeff Moden - Thursday, October 18, 2018 12:34 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 18, 2018 at 10:49 am

#2010261
RE: Using your critical eye to see something positive

Jeff Mlakar - Thursday, October 18, 2018 9:24 AM
Jeff Moden - Thursday, October 18, 2018 9:11 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 18, 2018 at 9:37 am

#2010247
RE: A $3 Billion Donation

Eric M Russell - Thursday, October 18, 2018 9:10 AM
Maybe Microsoft is wanting to following the casino business model where free food...
--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 18, 2018 at 9:32 am

#2010246
RE: Using your critical eye to see something positive

Jeff Mlakar - Thursday, October 18, 2018 8:57 AM
I like to look at this phenomenon of the negative DBA like this: the...
--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 18, 2018 at 9:12 am

#2010241
RE: How to build an app with GUI that works with SQL Server?

What would be cool to find out is if this is a self-imposed project by the OP or a project imposed by some instructor.
--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 18, 2018 at 8:58 am

#2010238
RE: Using your critical eye to see something positive

Jason- - Thursday, October 18, 2018 6:46 AM
Jeff Moden - Thursday, October 18, 2018 12:34 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 18, 2018 at 8:21 am

#2010233
RE: How do you handle SSIS package merging between two BI teams?

Phil Parkin - Thursday, October 18, 2018 7:13 AM
xsevensinzx - Thursday, October 18, 2018 6:47 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 18, 2018 at 7:36 am

#2010224
RE: How to build an app with GUI that works with SQL Server?

Jonathan AC Roberts - Thursday, October 18, 2018 7:05 AM
sgmunson - Thursday, October 18, 2018 6:58 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 18, 2018 at 7:21 am

#2010221
RE: Using your critical eye to see something positive

I can't speak for others but I almost always offer a better solution when I say "No". The trouble is... it doesn't help. They say that DBAs have this negativity...
--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 18, 2018 at 12:34 am

#2010177
RE: Casting one datetime as date converts other datetime fields

robert.wiglesworth - Wednesday, October 17, 2018 9:16 AM
OK, so I figured this out. It was in SSIS. I looked at the metadata...
--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 17, 2018 at 11:38 pm

#2010174
RE: Adhoc Query Question

bugg - Wednesday, October 17, 2018 8:03 AM
Jeff Moden - Wednesday, October 17, 2018 7:55 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 17, 2018 at 11:36 pm

#2010173
RE: A $3 Billion Donation

drew.allen - Wednesday, October 17, 2018 9:43 AM
There is a board game, also called "To Serve Man" that carries on this theme. ...
--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 17, 2018 at 11:25 pm

#2010172
RE: How to flip tables in sql server 2014

andycadley - Wednesday, October 17, 2018 3:38 PM
Jeff Moden - Tuesday, October 16, 2018 6:36 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 17, 2018 at 11:20 pm

#2010171
RE: Feature request, please...

Steve Jones - SSC Editor - Wednesday, October 17, 2018 3:44 PM
We are in process for a migration to WordPress as 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)

October 17, 2018 at 11:02 pm

#2010169
RE: Best place to change column width and type?

palandri - Wednesday, October 17, 2018 12:53 PM
I don't understand your response, I didn't ask the right question, or I didn't create...
--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 17, 2018 at 10:51 pm

#2010168

Viewing 15 posts - 10,891 through 10,905 (of 59,099 total)