Jeff Moden

Forum Replies Created

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

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
RE: Help interpreting deadlock output

James Lavery - Wednesday, October 17, 2018 7:46 AM
One thing to note is these issues have only started being reported...
--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 12:04 pm

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

You're looking for the wrong thing. The "Best Practice" is to know what the data from the flat file is and to properly set the target staging table to 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 17, 2018 at 11:56 am

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

robert.wiglesworth - Wednesday, October 17, 2018 10:57 AM
Ya, coincidence I guess. I have seen some people bashing TOAD, but there are 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:47 am

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

Phil Parkin - Wednesday, October 17, 2018 8:15 AM
Jeff Moden - Wednesday, October 17, 2018 7:48 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 9:37 am

#2010100

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