Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,616 through 3,630 (of 59,098 total)

Reply To: Using T-SQL over PoSh
My two favorite questions are becoming...
1. Is there a reason why this MUST be done in PowerShell?
2. Is there a reason why this MUST be done in Python?
The answer both...
--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)
April 24, 2022 at 5:23 pm

#4021416
Reply To: How to add background color of row based to existing SP/query

SQLisAwe5oMe wrote:
Hi Jeff - just checking to see if you got a chance to test it.
Ok. I don't actually have any mirrored databases anywhere but I tested this the best...
--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)

April 24, 2022 at 4:18 am

#4021225
Reply To: Pre allocating free space to db growth

ratbak wrote:
Advantages of pre-allocation: Queries don't die when you suddenly run out of room in the middle of a transaction. No need to wait for file growth. No risk 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)

April 23, 2022 at 10:26 pm

#4021150
Reply To: Transaction log growth - Index Manintenance jobs & Database functional jobs

Step 1 would be to stop using REORGANIZE unless you actually know what it does on each and every index you have and, to be brutally honest, most people don't. ...
--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)

April 23, 2022 at 10:11 pm

#4021149
Reply To: Backup verify with third party tools

ramana3327 wrote:
Thank you. What will happen if the backup verify fail in one of the database? It will start again taking the backup or just tell us the verify option...
--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)

April 23, 2022 at 9:42 pm

#4021126
Reply To: Pre allocating free space to db growth
ramana3327 wrote:
I am thinking about the negative consequences of provisioning free space drastically high.
1. How much difference it will be in backup size and backup time
2. Restoring to the test...
--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)
April 23, 2022 at 9:22 pm

#4021124
Reply To: Handle TSQL Session exections terminated by users

Thanks. That was awesome. Told me a lot.
Random GUIDs are GOOD... But not like THAT!
First and as a bit of a sidebar, you good folks have done yourselves a pretty...
--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)

April 23, 2022 at 7:22 pm

#4021099
Reply To: Find Maximum Qty of fruits (regardless of fruit) which could be bought by $50

pietlinden wrote:
Maybe do the P*Q for the lowest priced fruits, sort that way, then do a running total. Filter for running total less than your threshold?
Spot on early suggestion, Piet!
--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)

April 23, 2022 at 3:00 am

#4020841
Reply To: Find Maximum Qty of fruits (regardless of fruit) which could be bought by $50

Jonathan AC Roberts wrote:
Thanks Jeff, well spotted, I totally missed it.
The first time I looked at it, SO DID I. 😀
Again, nice use of the "Relational Multiplication" method! I'm still thinking about...
--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)

April 23, 2022 at 2:59 am

#4020840
Reply To: Find Maximum Qty of fruits (regardless of fruit) which could be bought by $50

Jonathan AC Roberts solved this problem very nicely using the fnTally() function to due the "Relational Multiplication of Rows". If we tweak his good code just a little bit, 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)

April 23, 2022 at 2:33 am

#4020836
Reply To: Find Maximum Qty of fruits (regardless of fruit) which could be bought by $50
Jonathan AC Roberts wrote:
```
;with cte as
(
    select sum(t.price) over (order by t.price asc, v.N) RunningTotal, * 
      from #TEMP1 t
 ...
```
--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)
April 23, 2022 at 12:51 am

#4020802
Reply To: Find Maximum Qty of fruits (regardless of fruit) which could be bought by $50

Jeff Moden wrote:
I may have something wrong with my understanding of the problem but, according to the values you've provided, there is no combination of fruits in case #1 where 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)

April 23, 2022 at 12:21 am

#4020798
Reply To: Find Maximum Qty of fruits (regardless of fruit) which could be bought by $50

I may have something wrong with my understanding of the problem but, according to the values you've provided, there is no combination of fruits in case #1 where you can...
--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)

April 23, 2022 at 12:13 am

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

saliw768 wrote:
Hello,
I'm trying to get the first and last dates of all the months based on the current year.
1/1/2022
1/31/2022
2/1/2022
2/28/2022
3/1/2022
3/31/2022
Any help would be greatly appreciated. Thank you in advance!
You've got multiple...
--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)

April 22, 2022 at 11:51 pm

#4020796
Reply To: Scripting Makes Mistakes Easier Than Ever

It’s not “scripting” that makes mistakes easier... The real problem is "urgency of an issue". The same can happen when deploying code of any type. You covered what the real...
--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)

April 22, 2022 at 3:37 pm

#4020573

Viewing 15 posts - 3,616 through 3,630 (of 59,098 total)