Please be specific as to what kind of blocking occurs and how long it actually lasts.

Then, let's see some proof...

Alter FUNCTION fn_TableByPeriod(
@Period...

Did you terminate the previous statement with a semicolon?

Your subquesry:

SELECT MAX([Datetime])
  FROM [mydbtemp]
 WHERE [Tagvalue] = 2
   AND [Datetime] BETWEEN '2023-02-01 01:00:00' AND '2023-02-05 20:00:00'

returns '2023-02-03 07:00:00.000'

So your query is equivalent to...

Just wondering what is the point of @Period in function fn_TableByPeriod?

SELECT [Datetime] 
FROM [mydbtemp] 
WHERE [Tagvalue] = 1 
AND [Datetime] > (SELECT MAX([Datetime]) 
FROM [mydbtemp] 
WHERE [Tagvalue] = 0 
AND [Datetime] BETWEEN '2023-02-01 01:00:00' AND '2023-02-05...

The table you are selecting from (my_table) is not the table you have created (mydbtemp). Also the column names are different.

I think you meant to put this as your query:

Serious "chicken dinner" there for performance, Jonathan... here are the stats from a test on a million rows of 16 hex digits (8 bytes)...

 SQL Server...

Serious "chicken dinner" there for performance, Jonathan... here's stats from a test on a million rows of 16 hex digits (8 bytes)...

 SQL Server Execution Times:
...

That's because bigint stores integers as Two's complement, negative numbers need 2^64 (18446744073709551616) added to them to represent the number as an unsigned int.

            
March 15, 2023 at 8:47 pm
            
#4161185

            
            
                                                
        

That's because bigint stores integers as Two's complement, negative numbers need 2^64 (18446744073709551616) added to them to represent the number as an unsigned int.

SELECT...

I would guess your trigger should look something like this:

CREATE TRIGGER software_on_install_fill_in 
ON software
FOR INSERT, UPDATE
AS BEGIN
    SET NOCOUNT ON

    UPDATE...

It would help if you included the table ddl for package and software.

SELECT ID
FROM ExampleTable
GROUP BY ID
HAVING MAX(CASE WHEN Description = 'Apex' THEN 1 ELSE 0 END) = 0 OR
    MAX(CASE WHEN Description = 'BILL'...

It seems to be ordered by original post date descending.

Active Threads is ordered by last post date descending.