Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,421 through 3,435 (of 59,098 total)

Reply To: Starting on Monday

Thank you for the very kind feedback, WebRunner. Coming from such a long time regular as you, it means a lot. Thanks again.
Looking back at that, it might make 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)

May 31, 2022 at 8:25 pm

#4042281
Reply To: How to get the first and last dates of all the months of the current year.

Steve Collins wrote:
Jeff Moden wrote:
A bit of a sidebar... I almost always avoid both EOMonth and anything else that is used to calculate the last day of the month because so many...
--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)

May 31, 2022 at 7:53 pm

#4042253
Reply To: Parse txt file

Do all of the files have a similar issue? Perhaps you need to tweak the code to handle the anomalies. Frederico offered a hint about that above.
And, no... they're 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)

May 31, 2022 at 7:46 pm

#4042252
Reply To: Cool products for Cloud?

@inayarens ,
First, welcome aboard.
Understand that your reply looks like a "prelude to spam" that spammers regularly use to see if they successfully got a working account. They also later come...
--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)

May 31, 2022 at 3:01 pm

#4042121
Reply To: Extended event - slow queries and waits

As a bit of a sidebar, your slowest queries are frequently NOT your worst queries. Rather it's usually some fairly small stuff that gets called thousands of times per hour. ...
--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)

May 31, 2022 at 2:55 pm

#4042118
Reply To: Parse txt file

Bruin wrote:
I stated in early post I couldn't supply file but fill check table as you gave a good starting place... What about job_type in there twice?
Thx.
Check the code. 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)

May 31, 2022 at 2:22 pm

#4042111
Reply To: How to get the first and last dates of all the months of the current year.

wrote:
Thanks for the answer.
Hi and welcome aboard, Robert.
Understand that your reply looks like a "prelude to spam" that spammers regularly use to see if they successfully got a working...
--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)

May 31, 2022 at 2:19 pm

#4042109
Reply To: How to get the first and last dates of all the months of the current year.

A bit of a sidebar... I almost always avoid both EOMonth and anything else that is used to calculate the last day of the month because so many people forget...
--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)

May 31, 2022 at 2:16 pm

#4042106
Reply To: Looking for some guidance on avoiding Scalar UDFs for DB lookups

Sorry... not enough coffee yet. Misread some code and removed the post.
And I totally agree with Johan... avoid Scalar UDFs at all costs. They even prevent parallelism if you 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)

May 31, 2022 at 2:06 pm

#4042105
Reply To: Iterate and reorganize subset of database tables

ktflash wrote:
Thanks for the reply.
Weird that this is somehow not more public knowledge since the problem seems to be pretty impactful and somehow mentioned "no where" in most (popular) google...
--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)

May 31, 2022 at 2:01 pm

#4042064
Reply To: Iterate and reorganize subset of database tables

Referring to the following page, search for the number 128. It turns out that's a threshold and its 128 extents. Since an extent is 8 pages and there 128 of...
--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)

May 31, 2022 at 8:04 am

#4041922
Reply To: Decoding the Code

Great "Decoder" post. Thanks for taking the time to put it together, Steve. You're the best!
Joining in the "Decoder" fun, decode this. 😀 Folks like Lynn Pettis will have 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)

May 31, 2022 at 6:32 am

#4041878
Reply To: Looking for some guidance on avoiding Scalar UDFs for DB lookups

SteveOC wrote:
Hello Johan.
I have a couple of Scalar Functions that are sub-second.
1 that I use every day passes an IP Address/Subnet in and returns a human friendly site name by...
--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)

May 30, 2022 at 11:29 pm

#4041766
Reply To: How to Navigate through folders to find .zip file

Thanks for the feedback, Thom. I appreciate 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)

May 30, 2022 at 2:19 pm

#4041607
Reply To: Iterate and reorganize subset of database tables

Also, if you need something "right away", they do have a previous presentation of mine on the subject. I have a couple of "mis-speaks" that I made during the "heat...
--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)

May 30, 2022 at 2:08 pm

#4041603

Viewing 15 posts - 3,421 through 3,435 (of 59,098 total)