I suppose that if you don't want the LOB data in the temporal table, you could move all LOB data to an extension table with the same PK as the...

The Above sample one works fine as it is. When I include it in my SP. It throws the below error.

The conversion of a nvarchar data type to a...

In most cases, performance issues are in the actual code.  If you post the ACTUAL execution plan, we might be able to see where the pain points are.

I'm not a DBA, but there are a few alarm bells right off the bat.

• C drive has 4.99GB free out of 49.99 GB - Windows tends to get rather...

Hi Jeff,

Hi took a four column data set containing waiting times measurements with 1,006,934 rows and then used the median function to calculate the median wait.  The query execution...

You haven't give us the table structure as requested.  Also your examples are not readily consumable sample data.

So, maybe this guess about your data will help

CREATE TABLE...

You cannot pass a #Table as a param, but what you can do is declare a #Table in proc 1 and then call proc2 from proc 1, and it will...

If you are stuck with the delimited strings, I would start bu using one of the locally produced high-speed string splitters

/****************************************************************************************************************
*** SOURCE:  http://www.sqlservercentral.com/articles/SQL+Server+2012/106903/
***   ...

You can turn the code into a function

CREATE FUNCTION dbo.itvfGetDays(@TheDate date)
RETURNS TABLE WITH SCHEMABINDING AS 
RETURN SELECT TheDay  = CASE DATEDIFF(dd, 0, @TheDate) %7
  ...

Something like this

DECLARE @TheDate date = '2019-12-17';

SELECT TheDay = CASE DATEDIFF(dd, 0, @TheDate) %7
             ...

• This reply was modified 5 years, 9 months ago by DesNorton. Reason: Fixed the offset for Day1

We have a lot of legacy code that was written loooong...

Darnit Jeff

Where does you mind go to come up with such perlers?

But how do you persist the numbers already used?

If you use a SEQ object, SQL...

You have not given us much to work with.

Here is a generic pattern that should get you started

DECLARE @StartDate date = '2019-11-02';
DECLARE @EndDate   date =...

Considering that you only have 4 digits for your number, I am assuming that this is a low volume system.

In that light, you could use a watermark table to create...