Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,906 through 10,920 (of 59,099 total)

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
RE: A $3 Billion Donation

jasona.work - Wednesday, October 17, 2018 7:57 AM
Well, to be fair any time a business makes a choice like this, someone, somewhere...
--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 8:09 am

#2010066
RE: Are the posted questions getting worse?

jasona.work - Wednesday, October 17, 2018 7:45 AM
Well, today marks the day fall is officially here for me...
I'm turning on the furnace...
--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 8:01 am

#2010059
RE: Adhoc Query Question

Just adding a single space to a query will cause a new plan to be generated. It's one of the reasons why it's so very important to parameterize code, especially...
--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 7:55 am

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

Data Cruncher - Tuesday, October 9, 2018 6:55 AM
How do you handle shared SSIS projects?
It's easy for...
--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 7:48 am

#2010053
RE: Is Database Administration a Branch of Data Engineering?

elea.grig - Wednesday, October 17, 2018 6:41 AM
I want to know the exact difference of DBA and Data Engineer. Is a DBA...
--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 7:37 am

#2010046
RE: Can anyone suggest a SQL Server Advanced course?

Data Cruncher - Wednesday, October 17, 2018 4:44 AM
Hi!
While ago, I had a lot of fun solving the sql-ex.ru queries. Moreover, seeing...
--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 6:22 am

#2010026
RE: Find and replace third occurrence of the string

Just an interview tip... if they ask you something like this and you don't ask if it will always be just the 3rd occurrence or if it could be ANY...
--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 6:08 am

#2010024
RE: Read Length of first Row and Header Row Delimiter through SSIS Script Task

rocky_498 - Tuesday, October 16, 2018 10:01 AM
Jeff,
I don't have words to say THANK YOU for your help. Very professional way to...
--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 16, 2018 at 7:35 pm

#2009980
RE: EBCDIC file is getting loaded with all special characters in my table

frederico_fonseca - Tuesday, October 16, 2018 5:29 PM
Just a quick note to say this is not forgotten - just complex and with...
--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 16, 2018 at 6:59 pm

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

andycadley - Tuesday, October 16, 2018 5:17 PM
Jeff Moden - Tuesday, October 16, 2018 2: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 16, 2018 at 6:36 pm

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

andycadley - Wednesday, October 10, 2018 8:53 AM
vikasjagadale8 - Sunday, October 7, 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 16, 2018 at 2:36 pm

#2009963

Viewing 15 posts - 10,906 through 10,920 (of 59,099 total)