We haven't been using branching at all.  I'm not sure how it works.
Do you have a link to some fairly idiot-proof info?

As for QA, it's done on...

Thanks Mark - I'll pass this to our licencing people and see what they say.

Hi Mark

I work for my local NHS Trust.
I'll dig out the licence terms (unless you have a handy link?) and have a look.

Thanks Mark.
I'm not sure we can do that as it's for a business.

From the comments on here already, there wasn't much point. 🙁

I'll have to do some research into those, but that might be the best idea.
Unfortunately, because it will affect one of the tables of our main database (and the...

I was afraid of that, but thanks anyway.

Looks like an "improvement suggestion" is heading back to the vendor.

Sorry folks, can't even add in a computed column (persisted or otherwise).
I know this is a bit of hassle, just wanted to check I didn't have any more option...

DDL for each table as follows:-
CREATE TABLE [dbo].[PcsAcct_Interventions](
    [SourceID] [varchar](3) NOT NULL,
    [VisitID] [varchar](30) NOT NULL,
    [InterventionUrnID] [varchar](83) NOT NULL,
    [RowUpdateDateTime] [datetime] NULL,
    [Intervention_PcsInterventionID] [varchar](23) NULL,
    [InterventionStatus]...

I've never used Full Text Search.

This is my current query:-
SELECT
    M.PcsAssmntDataID
  ,I.VisitID
  ,M.IdentifierID
  ,I.InterventionUrnID
  ,I.InterventionStatus
FROM
    PcsAcct_Interventions AS I
    INNER JOIN...

@chris-2 - Perfect, thank you.  I'll swap that in and replace a lot of joins and see time improvements I get.

@Ron - That's only for that FACT table...

@chris-2 - As requested, I've dropped 100 records from Dim Date and Dim Time into a spreadsheet (hopefully a usable format for you).
Each of the Dims has a record...

@Paulo - Dim_Date has 91312 records, Dim_Time has 86401 records and Dim_APC_Theatres_Delay_Reason has 116 records.
I'm not sure about using CTEs but I'll give it a go and see what happens.

Thanks both.

Looks like I've got a lot of reading to do.