Viewing 15 posts - 9,031 through 9,045 (of 59,078 total)
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...
July 15, 2019 at 9:30 pm
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...
July 15, 2019 at 7:16 pm
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...
July 14, 2019 at 2:44 am
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...
July 14, 2019 at 2:24 am
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...
July 14, 2019 at 2:04 am
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...
July 14, 2019 at 1:30 am
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...
July 14, 2019 at 1:09 am
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...
July 13, 2019 at 2:36 pm
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.
July 13, 2019 at 3:11 am
If you don't have a calendar/date dimension - you can do something like this:
Declare @startDate date = '2017-05-07'
, @endDate date...
July 13, 2019 at 3:01 am
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...
July 12, 2019 at 11:35 pm
...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.
July 12, 2019 at 11:31 pm
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...
July 12, 2019 at 4:54 pm
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...
July 12, 2019 at 3:22 pm
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...
July 12, 2019 at 2:30 pm
Viewing 15 posts - 9,031 through 9,045 (of 59,078 total)