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

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

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

Awesome editorial.. 😉

It really hits the spot in reminding us all how much our own mindset and view on the world influence ourself, but also all the people around us....

Very well-thought post Steve.

I think you hit one of the bigger issues with us as a generation of "spoiled" kids.

Lots of people expect "it all" from all other people/companies,...