Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,591 through 4,605 (of 59,098 total)

Reply To: How to calculate Monthly aggregates from daily data

The latest version of the code works just fine now. I also took a look at your expected output. We don't need to create any code to know that your...
--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)

September 27, 2021 at 1:12 am

#3933303
Reply To: How to calculate Monthly aggregates from daily data

You really need to actually try to run the code you posted before you post it. Heh... you even apparently ignored what I told you what was wrong with 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)

September 27, 2021 at 12:01 am

#3933290
Reply To: GUIDs as clustered index

Ok. That sounds like the only reason you're adding the GUID is to try to avoid fragmentation. By itself, that's probably not a good enough reason. And, again, there's no...
--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)

September 26, 2021 at 11:54 pm

#3933287
Reply To: Conversion failed when converting date and/or time from character string

Not to mention "Y", "N", month names with no reference to a year and much more.
--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)

September 26, 2021 at 11:05 pm

#3933279
Reply To: How show only first friday of every month

I definitely have an appreciation for the "old" days. I used to be able to read the holes on a Hollerith card and tell you what it said. 😀
So, thanks...
--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)

September 26, 2021 at 10:11 pm

#3933271
Reply To: GUIDs as clustered index

Call it what you want, using a GUID to "represent the PK" or vice versa makes no sense to me. Both columns are fixed width (unless you've done row or...
--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)

September 26, 2021 at 9:59 pm

#3933266
Reply To: How to calculate Monthly aggregates from daily data

I really appreciate what you tried to do with the readily consumable data but it's broken. The table creation is broken and the table to be inserted into is not...
--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)

September 26, 2021 at 9:50 pm

#3933265
Reply To: GUIDs as clustered index

To be honest and with the understanding that I have no real good grip on what your processes require, I see no serious merit in having both the IDENTITY column...
--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)

September 26, 2021 at 7:29 pm

#3933240
Reply To: GUIDs as clustered index

Steve Collins wrote:
vsamantha35 wrote:
So, they came up with a workaround as below.
- Introduced a new column as BIGINT column. - Made the bigint column as NOT NULL IDENTITY(1,1) with clustered...
--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)

September 26, 2021 at 4:05 pm

#3933218
Reply To: Volunteer For Something

Grant Fritchey wrote:
meelan wrote:
Hi Grant
Nice post and Thanks
By the way, what is your call sign?
KC1KCE
And thanks.

At home, apparently my call sign is "DINNER!" 😀
--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)

September 25, 2021 at 6:03 pm

#3933076
Reply To: How show only first friday of every month

On the "hoping" thing, that was just a bit of "before I had enough coffee" conversation. 😀
On Zidar's approach, and like I said in my response, the method that he...
--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)

September 25, 2021 at 6:00 pm

#3933073
Reply To: Linked Server location?

Heh... call the folks that are on the infrastructure team. They'll know.
--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)

September 25, 2021 at 4:29 am

#3932960
Reply To: Thank a Mentor

Steve... you not a mentor for me that that doesn't stop you from being a hero of mine. You've kept this site going and inspired a whole world of mentors. ...
--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)

September 25, 2021 at 4:27 am

#3932959
Reply To: Wait type LATCH_EX [NESTING_TRANSACTION_FULL] - and blocking.

VoldemarG wrote:
Well. I am pretty sure that it is not due to recompile because it recompiles every time anyway as an old-asp-concatenated sql statement. But also I went the MAXDOP...
--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)

September 25, 2021 at 3:05 am

#3932954
Reply To: Wait type LATCH_EX [NESTING_TRANSACTION_FULL] - and blocking.

VoldemarG wrote:
Additionally, I am still strongly thinking about adding more files to TEMPDB. Because all the blockees choke on the tempdb latches.
I have found that's usually not the problem but...
--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)

September 25, 2021 at 2:57 am

#3932951

Viewing 15 posts - 4,591 through 4,605 (of 59,098 total)