Hi again Chandran.

I am not looking for help solving a specific scenario, we have databases running at several 100 different customers, ranging from sub-GB to multiple TB. With a standard...

Nice article, has a few follow up questions/wonderings

We see some of the same at some customer sites, but in general we follow the MS Guidelines of setting MAXDOP to the...

Thanks Dennis

Looking into the "OR" solution, at first glimpse it seems like the query optimizer is missing something though.

In the UNION solution I have 45, 8 and 3 reads in...

Hi Drew and Dennis

Thanks for the feedback.

@Drew, I cannot produce sample data for it, as I can only reproduce it at this one customers site. They have above 20 mio...

Long time no see..

Revisited this to close it for now.

Installed a mint SQL 2019, and it doesn't seem to include .pdf when executing.

SELECT * FROM sys.fulltext_document_types

Neither does...

We have been discussing Elastic Search - our challenge is currently our deployment environment.

A single customer typically has a single land based installation, and potentially 100's of vessel installations, which...

I will try to capture it during the next days.

Today and yesterday the task was quickly done and only ran outside office hours. So when the customer was there to...

William, yes, if I create a new instance I would have to change connectionstrings, but that is ok. We control the clients accessing the databases, and are only a few...

Ok, what I hear is, and correct me if i'm wrong.

I can use the attach/detach process. In most cases it would work smoothly, but if it doesn't then I want...

Hi

Just to follow up.

Getting the PDF iFilter working correctly solved the case, and made indexing much better.

I tried adding the path to iFilter installation in system PATH.

https://blog.sqlauthority.com/2018/02/12/sql-server-full-text-search-not-working-pdf-documents/

I was a bit...

Update - just as I pressed send on the post, another thing came to my mind,.

I tried to update a PDF file record, from the assumption that maybe it was...

You are not that far from the truth. 🙂

We have...

Hi all

Thank you very much for all the resources.

I have been reading through a great deal of it by now and forwarded Glenn Berrys scripts to the customer....

I will take a look at those scripts as well in my own little sandbox at first.

Then I can try to push them on to the customer DBA as...

What can i say.. I...