Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,351 through 4,365 (of 59,069 total)

Reply To: Review Ola hallengren indexoptimize parameters

frederico_fonseca wrote:
regarding reorganize - there is an exception to this - if you have columnstore indexes that are frequently subject to deletions or that are subject on inserts in small...
--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)

November 5, 2021 at 5:52 pm

#3948449
Reply To: Review Ola hallengren indexoptimize parameters

That's the gist of it. If you have indexes where logical fragmentation actually does matter for large range scans, you might want to include those but, again, that's going to...
--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)

November 5, 2021 at 4:53 pm

#3948429
Reply To: New Index Maintenance Methods Recommended by Microsoft

As a bit of a sidebar, wouldn't adding more files add to the problem you spoke of previously?
--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)

November 5, 2021 at 4:42 pm

#3948423
Reply To: New Index Maintenance Methods Recommended by Microsoft

ScottPletcher wrote:
Jeff Moden wrote:
You're presuming an awful lot. Why would you want "at least 2 files per filegroup" for a single table?
To spread the I/O out, the typical reason for...
--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)

November 5, 2021 at 4:41 pm

#3948422
Reply To: Identify INT,BIGINT,character in stored proc

thbaig wrote:
now I am not discarding wrong data , but sending it back in output.
Ah... that's the ticket. Thanks for taking the time to explain. I was really concerned 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)

November 5, 2021 at 3:52 pm

#3948394
Reply To: Best practice to store - How many days, minute and second ?

Adelia wrote:
Jeff Moden wrote:
Adelia wrote:
Thanks to all
Adelia,
Don't go yet. I asked you some questions about datatypes that you've not answered yet. If you let me know that the datatypes of 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)

November 5, 2021 at 3:39 pm

#3948389
Reply To: Review Ola hallengren indexoptimize parameters

@databases nvarchar(max)='USER_DATABASES'
@FragmentationLow nvarchar(max) = NULL, /* don't defrag low fragmented */
@FragmentationMedium nvarchar(max) = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE', /* left out index_reorganize because of https://www.sqlservercentral.com/forums/topic/rebuilding-and-reorganizing-indexes/page/2/?bbp-ajax=true */
@FragmentationHigh nvarchar(max) = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationLevel1 int = 30, /* threshold medium...
--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)

November 5, 2021 at 3:16 pm

#3948381
Reply To: Review Ola hallengren indexoptimize parameters

Ah... sorry. Looking back at the original post, I see that REORGANIZE was left out. That's ok... it's still worth mentioning for other people that may read this thread.

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

November 5, 2021 at 1:48 pm

#3948336
Reply To: Review Ola hallengren indexoptimize parameters

Yes. Do not use REORGANIZE. It doesn't work the way you think it does. It's so bad on indexes that fragment that it's actually the cause of the myth 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)

November 5, 2021 at 1:46 pm

#3948335
Reply To: AWS RDS - MS Sql server

I don't know about those stored procedures and can't help there.
Of a much larger concern, suppose you want to restore just one database? Go check the documentation on that. IIRC...
--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)

November 4, 2021 at 4:35 pm

#3947971
Reply To: New Index Maintenance Methods Recommended by Microsoft

You're presuming an awful lot. Why would you want "at least 2 files per filegroup" for a single table?
Also, I can see some instances where you might have specific reason...
--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)

November 4, 2021 at 4:26 pm

#3947962
Reply To: SSRS reports that use a data component

Understood but that's not my question. To be more clear, you stated that...
I'd rather write components in a project written in C# that yield the results that would be...
--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)

November 4, 2021 at 4:02 pm

#3947952
Reply To: Identify INT,BIGINT,character in stored proc

thbaig wrote:
Thank you. TRY_Convert exist in my version
Now that you have your answer, would you please tell us what your stored procedure is doing? I'm really interested in why bad...
--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)

November 4, 2021 at 3:52 pm

#3947944
Reply To: New Index Maintenance Methods Recommended by Microsoft

ScottPletcher wrote:
Of course that method does not work with any cross-table constraints on the table, since constraints must be in the same filegroup (IIRC).
Try it and find out that 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)

November 4, 2021 at 2:59 pm

#3947923
Reply To: New Index Maintenance Methods Recommended by Microsoft

ScottPletcher wrote:
Of course that forces the entire table to be rewritten every time. In a typical rebuild, often large parts of the table do not need rewritten because they haven'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)

November 4, 2021 at 2:53 pm

#3947920

Viewing 15 posts - 4,351 through 4,365 (of 59,069 total)