Thanks Federico - I recall being told long ago that this was set at Instance level - I just checked using that link and compress backups is ticked. I do...

OK - found a bit more - here is a snip from the History for the Maintenance Plan (Backup step)

BACKUP DATABASE [DBAUtilities] TO DISK = N''O:\Backups\Daily\DBAUtilities\DBAUtilities_backup_2023_02_11_053151_2683033.bak'' WITH NOFORMAT, NOINIT, NAME...

Thanks both.

I have been trying to get more information on this since I don't setup or maintain the schedules. From what I can tell this is actually an SSIS package...

As Above - I ran in test for a Draft that did exist and one that didn't.

Where the Draft existed (1000000) the Number of Rows Read in the Actual Execution...

Thanks again.

I think that from what I am reading the Default Clustering Key for the CI is the Primary Key, but this can be changed, which is probably where my...

Thanks Both - I understand what you are saying and it had to be there somewhere but I am still a bit lost since the CI is not referenced in...

Thanks Grant.

It looks like it didn't like the .sqlplan file type after all even though it is an allowed file type so I have tried using  PasteThePlan for the first...

Interestingly I found that a setting of 8 (vs 6) does speed up the original slow query significantly it testing.

Perhaps it is time to increase the value due to increased...

Hello Frederico.

Thanks for the response - COTP is set to 45.

Why would COTP affect the same query differently, whether it has CHARINDEX or not, and why would a MAXDOP of ...

Hello and thanks for the response (for some reason I am not getting notifys).

I had another think and tried varous new ways to construct a search in Google and eventually...

Thanks all. I managed to get it to do what I needed by breaking down into 3 queries and can run all 3 within 20 seconds. It it was not...

Hello Johan.

I have a couple of Scalar Functions that are sub-second.

1 that I use every day passes an IP Address/Subnet in and returns a human friendly site name by scanning...

Hello Jeff.

Thanks for hanging in there. I have a meeting tomorrow to discuss my thoughts on this with peers.

However, your sig has always been something that was at the back...

Hello again Jeff.

Re-reading your reply and perhaps I misunderstood the question.

There is 1 Price Table containing all Price records and there is 1 Price Detail Table containing all monetary values....

Hello Scott.

Thanks for the reply.

I have already determined that iterative DB lookups in a Scalar Function is not the way to do this and, so am looking at starting from...