Jeff Moden

Forum Replies Created

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

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
RE: Casting one datetime as date converts other datetime fields

robert.wiglesworth - Tuesday, October 16, 2018 9:55 AM
It is TOAD for SQL Server. I just tried the same code in Management Studio...
--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 1:59 pm

#2009954
RE: Audit Trial help

SQL learner22 - Tuesday, October 16, 2018 1:30 PM
we should be able to capture any changes to any column in 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 16, 2018 at 1:51 pm

#2009951
RE: Deleted

Heh... being at retirement age and looking back, I can tell you that two of the most important things for a job are 1) doing it with people that you...
--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 9:43 am

#2009903
RE: What are some really dumb things you could write in a SQL Query

andrew gothard - Tuesday, October 16, 2018 5:09 AM
Jeff Moden - Wednesday, October 10, 2018 6:29...
--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 9:38 am

#2009902

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