Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,191 through 8,205 (of 59,072 total)

Reply To: Expect the Unexpected with DiRT

David.Poole wrote:
Worth reading about Netflix and the Chaos Monkey approach
Do you have any links? (or did I simply miss them in the article?)

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

December 5, 2019 at 2:03 pm

#3704970
Reply To: Database file size question

Mike Scalise wrote:
Thanks, Jeff!
I completely understand your rationale for shrinking the log file to 0 for the reasons you mentioned, but let me ask—in your experience, how resource intensive is the...
--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)

December 5, 2019 at 2:00 pm

#3704960
Reply To: Database file size question

IMHO, your analysis is spot on, Mike. You only need to decide on what the growth of each file should be in MB.
Since the Log file did grow by 10%...
--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)

December 5, 2019 at 4:52 am

#3704627
Reply To: Find rows older than 60 days with Epoch time format

Isabelle2378 wrote:
Thank you for your reply! That is very helpful 🙂 I need to run this purge job once a week but unfortunately I don't know how many rows 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)

December 5, 2019 at 4:36 am

#3704626
Reply To: Expect the Unexpected with DiRT

Our annual DiRT testing takes place this weekend. We're not Google by any means but it's just as important to us. The whole company gets involved in one form or...
--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)

December 5, 2019 at 4:16 am

#3704622
Reply To: It's More Than What You Know

David Burrows wrote:
Jeff Moden wrote:
Exactly and well said. And if someone keeps in mind that there will almost always be...
2.A better answer...
Especially with my code :-/
Heh... so say we all about our...
--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)

December 4, 2019 at 10:08 pm

#3704536
Reply To: Slow deletes

Sam, I hope you didn't miss the following because that SHRINK FILE stuff isn't going to solve your slow deletes.
https://www.sqlservercentral.com/forums/topic/slow-deletes#post-3704281
--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)

December 4, 2019 at 9:44 pm

#3704533
Reply To: Slow deletes

MVDBA (Mike Vessey) wrote:
jeff- you just made me laugh out loud and spill my tea all over my new keyboard about job security. I was chatting to a guy I work with...
--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)

December 4, 2019 at 9:40 pm

#3704532
Reply To: Slow deletes

vsamantha35 wrote:
Yes. I tried the shrinkfile but it doesnt release free space which is around 500MB. I dont know why!!

Ok... I'm humbled. NICE CALL MIKE!!! 😀
--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)

December 4, 2019 at 9:38 pm

#3704531
Reply To: Are the posted questions getting worse?

Phil Parkin wrote:
I wonder whether I will be cast out from The Thread as a maverick grammar nutjob for suggesting that NSO would be a better abbreviation, given that 'verbal' means...
--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)

December 4, 2019 at 9:29 pm

#3704527
Reply To: How to speed up the query speed between different server tables

Jeff Moden wrote:
We combine OPENQUERY against a LinkedServer and it does appear to help performance quite a bit (especially when pointing at AS400s or IBM PowerSystems). I have no measured stats...
--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)

December 4, 2019 at 4:49 pm

#3704391
Reply To: Execution time before and after index creation for query with params

ebooklub wrote:
close connection/work with dev team is good ,but I am adapting to reality
I guess I'll have to introduce you to the idea of "Informative Pork Chop Dinners". 😀
--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)

December 4, 2019 at 4:46 pm

#3704389
Reply To: It's More Than What You Know

MVDBA (Mike Vessey) wrote:
Jeff Moden wrote:
Shoot... I'm just happy to be on someone's list. 😀 😀 😀
I meet Steve and Grant before they knew how to spell RedGate. I don't remember exactly but...
--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)

December 4, 2019 at 4:42 pm

#3704387
Reply To: Slow deletes

MVDBA (Mike Vessey) wrote:
one of the things we were taught(more than 20 years ago) was how to do capacity planning, how many rows per page, work out what was out of row...
--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)

December 4, 2019 at 4:36 pm

#3704385
Reply To: Slow deletes

MVDBA (Mike Vessey) wrote:
Jeff Moden wrote:
MVDBA (Mike Vessey) wrote:
another question - it's so blindingly obvious that I forgot to ask.
when you are shrinking, are you using truncateonly in the dbcc script?
Great question, Mike.
I'm thinking that...
--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)

December 4, 2019 at 3:45 pm

#3704368

Viewing 15 posts - 8,191 through 8,205 (of 59,072 total)