Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,601 through 3,615 (of 59,087 total)

Reply To: Pre allocating free space to db growth

That's a good idea but I don't believe that will reduce the impact on the log file when you use REORGANIZE.
--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 25, 2022 at 6:25 pm

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

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

April 25, 2022 at 6:21 pm

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

Ah... careful now... you can't rely on the default trace on a busy system for things like this. The lifetime expectancy of any row in our default trace is on...
--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 25, 2022 at 12:46 am

#4021517
Reply To: Using T-SQL over PoSh
skeleton567 wrote:
Jeff Moden wrote:
My two favorite questions are becoming...
Is there a reason why this MUST be done in PowerShell?
Is there a reason why this MUST be done in Python?
My...
--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 25, 2022 at 12:01 am

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

Viewing 15 posts - 3,601 through 3,615 (of 59,087 total)