Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,391 through 6,405 (of 59,089 total)

Reply To: How to create a minimal tally table and to describe its advantages (if any)

Your efforts are much appreciated but the COUNT(*) stuff is going to confuse the very newbies that you're trying to not confuse (by using fnNumbers as the name).
I've also found...
--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 22, 2020 at 4:55 pm

#3790156
Reply To: Missing constraint after backup and restore

gdf2020 wrote:
Hi @Grant Fritchey thanks for your reply, we are moving towards backup and restore on AWS RDS but in the meantime I need to use this procedure, can you...
--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 22, 2020 at 4:45 pm

#3790155
Reply To: Number weeks from April to September for every year

deepkaur@outlook.com wrote:
I want to number weeks from April to September for every year, such that week 1 starts 1st of April and ends the following Saturday and week 2 starts...
--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 22, 2020 at 3:55 am

#3789979
Reply To: Stored procedure using multi-valued optional parameter

slsmithstone wrote:
Hi Andrew-
Thanks for turning me on to Jeff Modon. Loved his article and sense of humor.
I corrected the length of the @status parameter to 250.
I put the following after...
--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 22, 2020 at 1:13 am

#3789967
Reply To: Searching for orphaned DB files on the SQL server

True enough. Thanks for the feedback.
--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 22, 2020 at 12:55 am

#3789965
Reply To: How to create a minimal tally table and to describe its advantages (if any)

Maybe my confusion on this subject is that maybe I've guessed wrong about what you mean by "Minimal" so let's look back at your original question...
Steve Collins wrote:
What is the minimal...
--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 22, 2020 at 12:11 am

#3789962
Reply To: Searching for orphaned DB files on the SQL server

Any MDF, NDF, or LDF file currently being used by SQL Server cannot be modified in any way. With that in mind (and it would also work if multiple instances...
--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 21, 2020 at 7:11 pm

#3789876
Reply To: Number weeks from April to September for every year

Johan Bijnens wrote:
Jeff published a wonderfull article called: Create a Tally Function
Thank you for the kudo. If you've not subscribed to the article discussion, you may want to. I've found...
--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 21, 2020 at 6:44 pm

#3789870
Reply To: How to create a minimal tally table and to describe its advantages (if any)

Steve Collins wrote:
Jeff, I was going to mark your response above as the answer but it actually doesn't answer the question. Your answer is merely complete and I asked for minimal. ...
--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 21, 2020 at 5:34 pm

#3789862
Reply To: How to create a minimal tally table and to describe its advantages (if any)

Steve Collins wrote:
Jeff Moden wrote:
Ah... almost forgot... What to do about the folks that claim that performance doesn't matter if you know that here will always only be a small number 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)

September 20, 2020 at 7:06 pm

#3789720
Reply To: How to create a minimal tally table and to describe its advantages (if any)

Steve Collins wrote:
That person's query also contained a RIGHT OUTER JOIN. When was the last time you actually saw one of those not in a textbook?
About 10 minutes ago. I use...
--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 20, 2020 at 6:55 pm

#3789719
Reply To: when to use Python in SQL Server

Mr. Brian Gale wrote:
Some things CAN be done in SQL, but can be done so much faster and/or easier in other languages.
While that is certainly true, I find that it's a matter...
--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 20, 2020 at 3:16 am

#3789681
Reply To: How to create a minimal tally table and to describe its advantages (if any)

Steve Collins wrote:
Ok here are two recent winning recursive cte's. Be gentle when evaluating the opposing answers 🙂
https://stackoverflow.com/questions/63922869/get-an-interval-of-dates-from-a-range-of-dates/63923536
https://stackoverflow.com/questions/63919706/fill-missing-months-on-a-date-query/63920844
As a bonus, here losing while using an ordinal splitter
https://stackoverflow.com/questions/63886788/extracting-date-from-text-in-sql-using-cursor/63887736
Thank you for posting those...
--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 20, 2020 at 12:19 am

#3789676
Reply To: How to create a minimal tally table and to describe its advantages (if any)

Ah... almost forgot... What to do about the folks that claim that performance doesn't matter if you know that there will always only be a small number of rows involved...
--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 19, 2020 at 9:46 pm

#3789671
Reply To: How to create a minimal tally table and to describe its advantages (if any)

Ok, here we go...
The code that you originally wrote generates the full range of values that the inline cascading CTE for the Tally cte can generate and it does so...
--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 19, 2020 at 8:07 pm

#3789665

Viewing 15 posts - 6,391 through 6,405 (of 59,089 total)