Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,221 through 8,235 (of 59,098 total)

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
Reply To: Are the posted questions getting worse?

p.s. I've also adopted the policy of NVO (No Verbal Orders), especially for "urgencies". It there's not a well documented ticket to support the urgency, it doesn't get done. While...
--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:15 pm

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

below86 wrote:
What I hate is when you get the 'Urgent' email on a request for some data. Then you spend the rest of the day working on it. Then 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 4, 2019 at 3:12 pm

#3704342
Reply To: Slow deletes

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 it's 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 4, 2019 at 2:55 pm

#3704291
Reply To: Slow deletes

p.s.
And please don't skip answering any of the questions... they're actually quite important to all of this and the "plan" that I have in mind. One of the problems 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 2:50 pm

#3704286

Viewing 15 posts - 8,221 through 8,235 (of 59,098 total)