a simple google search finds a few hits.

one of them is https://dba.stackexchange.com/questions/41961/how-to-find-all-positions-of-a-string-within-another-string

have a look at the following links for info

https://www.sqlservercentral.com/forums/topic/review-ola-hallengren-indexoptimize-parameters

https://www.youtube.com/watch?v=rvZwMNJxqVo

https://www.sqlservercentral.com/forums/topic/index-fragmentation-42

regarding your particular need to do it on a subset of tables - don't worry about creating a custom script for it.

Ola's...

• This reply was modified 3 years, 5 months ago by frederico_fonseca.

IF (SUSER_NAME() in ( 'DOMANINA\GMSA_999SQLAgt$', 'user', 'user3', 'user4'))

this is basic sql

having one of the above running you always have the statements on the database for investigation.

Even if they aren't consuming high CPU having the history (mainly the second query I...

I could not find it (and I'm sure you searched as well) - but you can do it manually with T-SQL.

what the wizard does on the background is defined in...

you don't do it when you have high cpu - you have it running all the time with 10,20, 30, 60 seconds interval or so depending on how busy your...

I'll let Jeff do some chopping but WHY Reorganize? this should be avoided almost at all costs (very few exceptions)

with db in simple recovery the following can cause the log to grow.

• Replication
• CDC
• Large size updates (or medium size parallel updates) / same for Deletes
• big indexes being...

the OP means the pipe "|" between strings

I think that knowing why and how that function is called so many times may help pointing you to a better solution.

how all those hierarchical rules are applied may also...

• This reply was modified 3 years, 5 months ago by frederico_fonseca.

SSAS memory settings are the culprit here.  In Enterprise edition, the memory limit for SSAS is the server max, so it is very probable that SSAS is competing against...

make sure that TCP/IP protocol is enabled on the sql instance -= need to do it on server itself

the query above would give an error with variable @FromDate as it is not declare WITHIN the @sql

if you are doing a exec @sql then this would fail - different...

likely your tabular server memory settings not setup correctly - these can be tricky and need to be set according to whatever memory is available to the particular tabular instance...

there are multiple things that can cause a connection to drop - increasing the timeout will not prevent those as it is only meant to prevent the timeout error itself.

for...