I had the same issue with LIKE '%searchterm%'. It took 18 minutes to search one million text files.

I changed to the "CONTAINS" statement and it went down to 1.5 seconds...

At the moment, i have about 1 million records and the search takes under 5 seconds, using '%like%'.

The 'PRO' table is not FTI.

Is it worth making it FTI to swap the 'like' to a 'contains' ?

Thanks for the feedback !

Many Thanks !

Not really sure how to tune the indexes.

I have approx 770k records in text file format, with full text indexing running.

I run a sql query to extract specific data,...

Update - I tried the dbcc shrinkfile again and it did not reduce the size, so i ran another translog backup. The translog backup from yesterday was 105 GB but...

Dumb question, but why do you need seperate full and log backups ?

In previous restores from full backups it has restored all files.

Thanks

log size - 98.7 GB

log space used - 0.61%

status - 0

I did a log file backup prior to the attempted shrink.

I realize that i need the log file, my comment...

data -23 GB

log -105 GB

Not looking for an argument, but why does MS offer a shrink capability if it is a bad idea ?

So how do i reduce the...

I took back ownership and the delete worked fine!

Thanks 🙂

So how do i delete them ?

thanks

Access 2007

The upsizing failed.

Ms Access, create new DB, database tools, sql server,

the error occurs on either new db or use existing db.

next, dsn name, sql server login, pw

the upsizing wizard only...