Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,481 through 15,495 (of 59,097 total)

RE: Are the posted questions getting worse?

ZZartin - Tuesday, March 7, 2017 12:33 PM
Neil Burton - Tuesday, March 7, 2017 12:14 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)

March 7, 2017 at 3:17 pm

#1932191
RE: Import problem

Sue_H - Tuesday, March 7, 2017 2:10 PM
That could just be me as SSIS just pisses me off sometimes.
Sue
I'm sensing...
--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)

March 7, 2017 at 3:10 pm

#1932189
RE: How to overcome the identity column "jump 1000" issue

Grant Fritchey - Tuesday, March 7, 2017 2:15 AM
Jeff Moden - Monday, March 6, 2017 9:12 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)

March 7, 2017 at 1:00 pm

#1932149
RE: Please explain difference between these terms

Ah...yup. Bad spelling on my part. Thanks for pointing it out. Hopefully, the OP understood the principle I was trying to get across. 😉
--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)

March 6, 2017 at 9:45 pm

#1931971
RE: How to overcome the identity column "jump 1000" issue

spaghettidba - Thursday, January 15, 2015 4:40 AM
It's a known issue. The TF resolves it, but IMHO a gap or jump in...
--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)

March 6, 2017 at 9:12 pm

#1931969
RE: Use date and time in sql statement for join, but not required in the output

jcelko212 32090 - Monday, March 6, 2017 8:00 PM
Jeff Moden - Monday, March 6, 2017 6:51 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)

March 6, 2017 at 8:46 pm

#1931968
RE: Use date and time in sql statement for join, but not required in the output

jcelko212 32090 - Monday, March 6, 2017 12:34 PM
>>I am using the date / time from a view to join on...
--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)

March 6, 2017 at 6:51 pm

#1931964
RE: Usage of CTE - Trick with Dates

EliG - Monday, March 6, 2017 12:57 PM
Jeff Moden - Monday, March 6, 2017 12:30 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)

March 6, 2017 at 4:07 pm

#1931956
RE: Usage of CTE - Trick with Dates

EliG - Monday, March 6, 2017 12:20 PM
The original article.
I'd recommend avoiding the rCTE in the original article. Please refer 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)

March 6, 2017 at 12:30 pm

#1931904
RE: Usage of CTE - Trick with Dates

EliG - Monday, March 6, 2017 11:56 AM
Interesting read - greatly appreciated.
One point to note: since the second query in the CTE...
--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)

March 6, 2017 at 12:17 pm

#1931900
RE: Usage of CTE - Trick with Dates

SoCal_DBD - Monday, March 6, 2017 8:58 AM
Awww Jeff..... I hang my head in SHAME!!! :crying: Original post revised as...
--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)

March 6, 2017 at 10:37 am

#1931875
RE: Help with % calculation please

Luis is spot on about how this occurred. As a simplification of what he posted, unless the SUM of a.fieldmissed will create a number larger than 13 significant digits, 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)

March 6, 2017 at 8:28 am

#1931830
RE: All Columns as Included

VastSQL - Sunday, March 5, 2017 10:32 PM
Jeff Moden - Sunday, March 5, 2017 12:05 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)

March 6, 2017 at 8:03 am

#1931816
RE: Please explain difference between these terms

Neil Burton - Monday, March 6, 2017 1:53 AM
I think you mean database principals rather than principles here Jeff. A search 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)

March 6, 2017 at 7:59 am

#1931811
RE: Create sql login for reporting activity

Eric M Russell - Monday, March 6, 2017 7:31 AM
Jeff Moden - Sunday, March 5, 2017 1:41...
--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)

March 6, 2017 at 7:56 am

#1931808

Viewing 15 posts - 15,481 through 15,495 (of 59,097 total)