Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,361 through 6,375 (of 59,072 total)

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

Steve Collins wrote:
However, it appears the OP didn't go for it and just only wants his kludge to be made to work.
Considering the way the OP asked the question, I'm 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 24, 2020 at 3:52 am

#3790543
Reply To: Size of table

caz100 wrote:
Hi
This probably a silly question but.....
If I query the size of a table and it shows 20 gigs in size, when I do a select * from that table...
--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, 2020 at 2:31 am

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

The reason why I wanted you to post your test harness is because you claimed that the Tally solution took 19 MINUTES to the rCTE's 12 MINUTES on that post. ...
--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 23, 2020 at 10:58 pm

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

Steve Collins wrote:
Jeff Moden wrote:
Steve Collins wrote:
Here's another one. It took 19 minutes vs 12 minutes for the rCTE. There's no sample data and no time for making any up. Hopefully the query...
--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 23, 2020 at 10:19 pm

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

jcelko212 32090 wrote:
I showed you can be put in a CTE, a view or used as a standalone query as needed.
Nope... you may have mentioned it but you've not "shown" anyone...
--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 23, 2020 at 10:18 pm

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

Steve Collins wrote:
Here's another one. It took 19 minutes vs 12 minutes for the rCTE. There's no sample data and no time for making any up. Hopefully the query is sound. ...
--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 23, 2020 at 9:37 pm

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

Steve Collins wrote:
jcelko212 32090 wrote:
Any time I've needed to populate a table of sequential numbers, I just done it by brute force. No recursion or fancy stuff. Remember the definition of place...
--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 11:29 pm

#3790240
Reply To: Dear Past Me on My First Day as a DBA

Cebisa wrote:
You definitely do work with all departments in the company, which is an aspect of the job that I like.
Heh... when I first heard of "DevOps", my thought 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)

September 22, 2020 at 5:15 pm

#3790164
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

Viewing 15 posts - 6,361 through 6,375 (of 59,072 total)