Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,086 through 2,100 (of 59,082 total)

Reply To: The Power of Community in Times of Uncertainty

Thanks, Ryan.
Thought I'd throw one more out there. It doesn't spell "community", but the community needs to know. 😀
https://www.postgresql.org/docs/

--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)

January 22, 2023 at 7:22 pm

#4140564
Reply To: The Power of Community in Times of Uncertainty

From the Article:
"A little more than 12 months into the new gig, I finally started to have a mind shift and look more earnestly for a Postgres family....
--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)

January 21, 2023 at 5:08 pm

#4140372
Reply To: Minimize Typing

I've found that a lot of people just don't give a damn.
I recently did a peer review of some rather length but vertically code where the table name was simply...
--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)

January 20, 2023 at 9:22 pm

#4140182
Reply To: Conventions when writing queries/stored procedures

edwardwill wrote:
...but I don't think I'll ever be converted to leading commas - I think that's at least partly because I'm an English language pedant and believe that a comma...
--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)

January 20, 2023 at 8:48 pm

#4140173
Reply To: Read data based on date-range in huge table is slow

ScottPletcher wrote:
I wouldn't just arbitrarily add a non-clus index without checking existing index usage ("index usage stats") AND reviewing missing indexes ("missing index" stats).
Nor would I change the Clustered Index...
--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)

January 20, 2023 at 8:36 pm

#4140171
Reply To: No experience with programming; how difficult is SQL for new prospect?

As a bit of a sidebar, I've not yet found an online video course for beginners that I actually like or think that does the job adequately. 🙁
--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)

January 20, 2023 at 7:32 pm

#4140153
Reply To: No experience with programming; how difficult is SQL for new prospect?
julunyeti wrote:
1. Microsoft's new journey and phase is causing many well developed areas of skills to be discarded. By the time we hit SQL Server 2016 the exams were robust...
--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)
January 20, 2023 at 7:21 pm

#4140143
Reply To: Read data based on date-range in huge table is slow

oRBIT wrote:
If "Time" were the first in order in the index, that would be much better?
Maybe for your query but might crush everyone else's performance.
Looking at the graphic that was...
--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)

January 20, 2023 at 7:15 pm

#4140142
Reply To: Conventions when writing queries/stored procedures

First of all, there have been religious wars over code formatting. Even the original post contains a possible declaration of such a war where the OP works.
I'm NOT trying to...
--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)

January 20, 2023 at 7:07 pm

#4140141
Reply To: SQL 2019 Standard - DB role, how to find create date and who created it.

If you know the date the principal was created AND you have a log file that spans that date, you can find it in the log file. I don't have...
--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)

January 20, 2023 at 1:27 am

#4139792
Reply To: Join aggregated queries via a date formatted YYYY-MM

saintor1 wrote:
Suggestions from kaj and Jonathan AC Roberts (both) work! Thanks to for spending a few minutes to solve this. I didn't know about the EOMONTH() function.
If your dates have...
--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)

January 20, 2023 at 12:50 am

#4139791
Reply To: How to turning 1 Row into 2 Rows following best practices?
Instead of making 2 passes through the table, use a CROSS APPLY to do the "unpivot". There IS an UNPIVOT operator but I don't care for 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)
January 20, 2023 at 12:38 am

#4139790
Reply To: Split string using multiple delimiters - version 2

ChrisM@Work wrote:
Iwas Bornready (9/15/2016)
ChrisM@Work (9/15/2016)
Interesting. It does a lot of work for the result. Have you speed-tested it against the house splitter? Here's one I knocked up in a couple...
--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)

January 20, 2023 at 12:25 am

#4139787
Reply To: What does date show?

To continue the math behind all of this and what the verbal description of what the code actually does, run the following code and let me know what number 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)

January 19, 2023 at 11:45 pm

#4139778
Reply To: What does date show?

Remember what I said about the DW datepart and DATEFIRST? What happens to the output when you change DATEFIRST and how does it relate to DATEFIRST insofar as the first...
--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)

January 19, 2023 at 11:42 pm

#4139777

Viewing 15 posts - 2,086 through 2,100 (of 59,082 total)