Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,281 through 5,295 (of 59,089 total)

Reply To: Are the posted questions getting worse?
Steve Jones - SSC Editor wrote:
Thoughts this crew might like this:
"Do not assume that index maintenance will always noticeably improve your workload."
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver15#index-maintenance-strategy
Steve Jones - SSC Editor wrote:
Thoughts this crew might like this:
"Do not assume...
--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)
May 13, 2021 at 6:45 pm

#3883134
Reply To: SQL 2012 Standard - Index highly fragmented

mjbc wrote:
I can say that some indexes rebuild from a 98% frag..... rebuild will take it down to less than 1%, give it an hour and that save index...
--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)

May 13, 2021 at 5:17 pm

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

You can get it from the following SQL Friday link, Lynn.
https://sqlfriday.net/past-sql-friday-sessions/sql-friday-17-jeff-moden-on-the-secret-to-high-performance-code-high-performance-test-data/
--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)

May 13, 2021 at 3:23 am

#3882846
Reply To: high CPU

Jeffrey Williams wrote:
For those recommending modifying the code - this is 3rd party vendor code and modifying that code without the vendors permission could invalidate the contract. Some vendors will...
--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)

May 12, 2021 at 7:46 pm

#3882696
Reply To: Non-Stop Learning

The new CE thing killed us. We had to turn it off.
With that in mind, Adaptive Joins has me scared to death.
I won't get into the other stuff on 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)

May 12, 2021 at 6:54 pm

#3882473
Reply To: high CPU

sqlguru wrote:
So would you recommend to run update statistics with full scan for the whole database weekly instead of normal update statistics? One thing I noticed when I compared...
--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)

May 12, 2021 at 6:47 pm

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

Luis Cazares wrote:
Ed Wagner wrote:
Luis Cazares wrote:
David Burrows wrote:
Jeff Moden wrote:
I normally don't do self-advertisement but I'm giving a presentation tonight at 6PM EDST online on an interesting subject. Here's...
--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)

May 12, 2021 at 6:33 pm

#3882460
Reply To: LATCH_EX when creating a clustered index

K. Thanks. One of your answers begs another question. Is that "other" database on the same instance?

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

May 12, 2021 at 6:21 pm

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

I normally don't do self-advertisement but I'm giving a presentation tonight at 6PM EDST online on an interesting subject. Here's the link to the Meetup and the abstract is also...
--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)

May 11, 2021 at 7:19 pm

#3882046
Reply To: high CPU

No... at least not yet. Have you done the most needy thing that's usually a problem with 3rd party databases? That "most needy" thing is to update statistics that need...
--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)

May 11, 2021 at 5:55 pm

#3882006
Reply To: LATCH_EX when creating a clustered index
Ummm.... ok... I want to remind you that NOTHING is a panacea! And, with that, I have a couple of questions...
1. What is the source of the data 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)
May 11, 2021 at 5:42 pm

#3882002
Reply To: Non-Stop Learning

eric.kero@orange.fr wrote:
Hi all
In France, we have a statement : « Qui trop embrasse, mal étreint ! »
I don’t know if there’s an equivalent one in english … a clumsy,...
--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)

May 11, 2021 at 4:21 pm

#3881967
Reply To: Minimum permission for user to grant execute on a stored procedure they created

Jeffrey Williams wrote:
@ScottPletcher & @JeffModen:
You both are assuming an environment where there is a dev/test/uat/prod set up. Not saying the OP doesn't have that - but there are environments where...
--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)

May 9, 2021 at 1:08 pm

#3881149
Reply To: SSIS File System Task to move csv Files between folders

TangoVictor wrote:
Jeff Moden wrote:
Why not just use a single DOS "MOVE" command instead of reinventing the wheel?
Jeff where are putting this command? In an Exec Process task or cmd...
--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)

May 7, 2021 at 7:20 pm

#3880668
Reply To: SSIS File System Task to move csv Files between folders

On the subject of compressed file destinations, true dat.
But, so far, everyone appears to be writing C as a replacement for simple CLI commands that already exist... it's kind 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)

May 7, 2021 at 6:14 pm

#3880644

Viewing 15 posts - 5,281 through 5,295 (of 59,089 total)