Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,046 through 9,060 (of 59,091 total)

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

Jeffrey Williams wrote:
Not so sure it is as bad as you stated, here is what it shows on my system.
The key here is that you have to make it system agnostic. ...
--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 15, 2019 at 11:51 pm

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

Eddie Wuerch wrote:
This is a great excuse to write a recursive query 🙂
Heh... no it's not. ( https://www.sqlservercentral.com/articles/hidden-rbar-counting-with-recursive-ctes )
--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 15, 2019 at 9:49 pm

#3663233
Reply To: Get the Datetime

GeorgeCopeland wrote:
I disagree Jeff, date math is a bad idea for any reason. When I have anything to say about it, it is not allowed. Maybe you know what 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)

July 15, 2019 at 9:30 pm

#3663224
Reply To: Get the Datetime

GeorgeCopeland wrote:
Even though you can do math on datetimes, don't do that. A datetime is not numeric, it is a data structure. Use the proper function for the type.
Actually, it...
--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 15, 2019 at 7:16 pm

#3663184
Reply To: The CUME_DIST ranking

Heh... I wonder how many people won't even try to answer because the test data is done using a cCTE to build a Tally Table and they don't know how...
--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 14, 2019 at 2:44 am

#3662730
Reply To: T-SQL sorting

TomThomson wrote:
Well, I have two problems with this QOTD. Or perhaps I see two faults in the new "improved" website. 1: The select statement isn't there - it's a meaningless...
--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 14, 2019 at 2:24 am

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

skeleton567 wrote:
Jeff, thank you for sharing your experience and memories with us. I believe you and I have lots in common. I think one gift you and I share is...
--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 14, 2019 at 2:04 am

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

TomThomson wrote:
I don't have gifts to be a DBA - DBA requires more patience than I usually have.
Ummm.... "patience". Hang on... let me look that up.
{insert 5 minute timer...
--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 14, 2019 at 1:30 am

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

Jonathan AC Roberts wrote:
Alan Burstein wrote:
Does anyone know why you shouldn't use CROSS APPLY for everything? Or does it sometimes come up with bad plans? CROSS APPLY and OUTER APPLY seem to be...
--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 14, 2019 at 1:09 am

#3662716
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, 1 months 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

Viewing 15 posts - 9,046 through 9,060 (of 59,091 total)