However, the main reason I suggested DATETIME2(0) was that the milliseconds which are always stored with DATETIME (and shown when doing a select) could have been the reason for...

I cannot see the image which you have embedded, can you try again?

Regarding this

The SSRS subscription is disabling itself if the report/query runs during a school holiday period between the...

Or better yet, store them as datetime2(0),...

We need a bit more clarity on this, I think.

Why are you storing start and finish dates as varchar() rather than DATETIME?

What are the parameters, and why are they 'incorrect'?...

What sort of advice are you looking for? How to print on large pieces of paper? Where to buy a printer? How to create an ER diagram? Best paper to...

I assume you're using OUTER APPLY because the val.* results can sometimes be NULL. But if there is always a match in val, switching to CROSS APPLY is likely to...

The error message does not appear to be a complete sentence.

Was there some other text at the end after "or this asymmetric key"?

UPDATE t1
SET t1.col1 = ISNULL(t1.col1,UpdateValue)

I see no responses from Kevin.

Ken's query is a code fragment, as I assume is obvious...

Before I ask this question, I want to let you know that I followed the advice @Phil Parkins advice and first asked this question on an Oracle forum, however I...

There are some very clever people in this forum who will certainly come up with great ideas to help you. But here is my first attempt at speeding things up.

First,...

Can you show us the code for the function?

I dunt know if it's just me, but the notifications seem to be pretty slow. I'm seeing some 6-10 minutes after a post has been made or a modmail...

Almost identical to Mark"s solution

WITH groups
AS (SELECT t.TestType
          ,t.TestDate
         ...

One idea would be to have two tables, one main table and one which holds data temporarily.

Push all of the individual transactions to the second table.

Periodically (as frequently as you...