Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,031 through 9,045 (of 59,067 total)

Reply To: Do You Have the Gifts to Be a DBA?

I'm with skeleton567 but maybe a little worse... I don't have a "gift". I have a passion.
I started my love for computers back in high-school in the late 60's where...
--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)

July 13, 2019 at 2:36 pm

#3662672
Reply To: Calculating Total # Days Per Year with Start Date to Today

rVadim wrote:
Can't you just group by YEAR(date) counting distinct dates?
Yes but, as you can see in my comments in the previous post, it's comparatively horribly slow.
--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)

July 13, 2019 at 3:11 am

#3662625
Reply To: Calculating Total # Days Per Year with Start Date to Today
Jeffrey Williams wrote:
If you don't have a calendar/date dimension - you can do something like this:
```
Declare @startDate date = '2017-05-07'
      , @endDate date...
```
- This reply was modified 7 years ago by Jeff Moden.
--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)
July 13, 2019 at 3:01 am

#3662623
Reply To: The "Numbers" or "Tally" Table: What it is and how it replaces a loop

Lynn Pettis wrote:
Jeff Moden wrote:
david.holley wrote:
Don’t make me post some examples. The issue isn’t so much the implicit join but rather understanding the criteria in the WHERE statement when it contains 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)

July 12, 2019 at 11:35 pm

#3662547
Reply To: Are the posted questions getting worse?

jonathan.crawford wrote:
...so now we're talking about CI/CD pipelines...
It will be interesting to know how you feel about that in 6 to 12 months. And, no... not being bit sarcastic here.
--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)

July 12, 2019 at 11:31 pm

#3662546
Reply To: The SQL Saturday Thread

Ray K wrote:
Jeff Moden wrote:
I've been accepted to speak at Providence, RI this year.
I'm presenting at Providence, too! I'll see you there, Jeff! Looking forward to seeing you again! This'll be my...
--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)

July 12, 2019 at 4:54 pm

#3662436
Reply To: The SQL Saturday Thread

I've been accepted to speak at Providence, RI this year. I'm presenting "Black Arts" Index Maintenance parts 1 & 2.
https://www.sqlsaturday.com/892/Sessions/Schedule.aspx
As a bit of a side bar, it'll be interesting...
--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)

July 12, 2019 at 3:22 pm

#3662420
Reply To: Is SSIS a dinosaur in Modern ETL?

KJKKPSI wrote:
Thank you all for the responses. I am a big supporter of staying within the MS stack and taking the natural migration to Azure, but there is a major...
--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)

July 12, 2019 at 2:30 pm

#3662405
Reply To: Is SSIS a dinosaur in Modern ETL?

David Burrows wrote:
Jeff Moden wrote:
The only exception is for daily transfer of 40GB in 140 KISAM files from a third party system and found SSIS the fastest method.
I don't know what 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)

July 12, 2019 at 2:14 pm

#3662397
Reply To: Are the posted questions getting worse?

TomThomson wrote:
below86 wrote:
I've been working with a young developer for over a year on trying to get her to format any SQL she writes, SSIS or SSRS packages. Since I...
--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)

July 11, 2019 at 7:12 pm

#3662151
Reply To: Are the posted questions getting worse?

TomThomson wrote:
Jeff Moden wrote:
TomThomson wrote:
Grant Fritchey wrote:
Chris Harshman wrote:
I don't trust anyone... not even myself! 🙂
My name is Grant Fritchey and I endorse this message. Except I'd change it slightly: I don't...
--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)

July 11, 2019 at 7:08 pm

#3662149
Reply To: Is SSIS a dinosaur in Modern ETL?

KJKKPSI wrote:
whereas a move to Talend would allow non-developer staff to handle integration task more easily due to it's drag and drop interface.
THAT RIGHT THERE is a very strong reason...
--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)

July 11, 2019 at 3:28 pm

#3662010
Reply To: Are the posted questions getting worse?

p.s. Venting is good... being old, I can tell you, it keeps you from farting so much. 😀
--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)

July 11, 2019 at 3:17 pm

#3662009
Reply To: Are the posted questions getting worse?

below86 wrote:
I've been working with a young developer for over a year on trying to get her to format any SQL she writes, SSIS or SSRS packages. Since I do...
--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)

July 11, 2019 at 3:16 pm

#3662008
Reply To: The "Numbers" or "Tally" Table: What it is and how it replaces a loop

david.holley wrote:
Don’t make me post some examples. The issue isn’t so much the implicit join but rather understanding the criteria in the WHERE statement when it contains the join information...
--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)

July 11, 2019 at 2:03 am

#3661824

Viewing 15 posts - 9,031 through 9,045 (of 59,067 total)