Here's the function to compute any given day for any given month:

SET ANSI_NULLS ON;
SET QUOTED_IDENTIFIER ON;
GO
CREATE FUNCTION dbo.GetFirstGivenDayOfMonth (@month date, @day tinyint...

I don't think you need a cursor for the index checks, although it's probably easiest to use a cursor to go thru the databases.  See if the code below will...

An inline function is a good idea, but I'll leave it scalar for now so you can just replace your existing function.  I would definitely not use I/O to do...

Cluster the header table on the date column.
Cluster the detail table on the key from the header table.  Get the key/fk by querying the header table first.
Edit: On the...

1) Technically, no, since clus key column(s) are automatically included in all non-clus indexes. But I like to explicitly code it when it's needed to make this index a...

Presumably the lower number is always first for single entries (if not, fix that! 🙂 ).


SELECT L.*
FROM Links L
WHERE L.ClientRef < L.LinkedClientRef

Agree. something like below.  Keep the trigger code as efficient as possible.  (Btw, cluster the new table on LOG_TIME first, to make processing and clean up of that table easier.)