Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,561 through 4,575 (of 59,069 total)

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
Reply To: How show only first friday of every month

Zidar wrote:
I am always scared when I see code I don't understand.
@zidar-2,
Thanks for the feedback and the code. It's always appreciated, especially when it's a slightly different take on things.
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)

September 25, 2021 at 2:49 am

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

VoldemarG wrote:
Reducing MaxDop helped, actually. elapsed time reduced from seconds to milliseconds now. Pre-creating temp tables did not change metrics but i understand what you all said regarding that 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)

September 24, 2021 at 10:47 pm

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

Steve Collins wrote:
In the tvf it seems possible to factor out a common table expression and the UNION ALL by adding +1 to the row goal and -1 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)

September 24, 2021 at 10:44 pm

#3932921
Reply To: How show only first friday of every month
1. How many times have you ever worked with anything that required an output of storage of any date earlier than 1900? I can see people taking exception to that,...
--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 24, 2021 at 10:34 pm

#3932919

Viewing 15 posts - 4,561 through 4,575 (of 59,069 total)