I notice you didnt post the query. Are you doing any SORT operations anywhere ?

ISNULL(d.DepartmentValidTo, DATEADD(d, 1, SYSDATETIME()))

A function in the ON clause can cause indexes to not be used. Can you tell from your newer execution plan after the index was created?

You could...

In your design you can create a batch history table. Then whatever script you run to insert into the tables from the data that only comes in twice weekly, add...

We are contemplating moving...

First, I don't know what they heck they did to it but there was a massive slowdown when 2019 came out and it's still slow in 2022[\quote]

We are contemplating moving...

Did you end up needing the #employees table ?

Plagarism , not cool.

Just to still make a note. I find the ISO_week property interesting.

select datepart(iso_week, '2025-03-30')

select datepart(week, '2025-03-30')

Maybe we need an article on this topic.

It does seem strange to me that there is a link, unrelated to the article, for a paid product.

Another good use case is using a join to a record set to do an update. This could be either another table or a CTE.  I see this often enough....

I dont imagine this type of processing being done on a live OLTP system. More likely a read only...

Nice illustration. If you could write or supply an introductory article on the basics on the pyodbc library I think others could also tinker for themselves the different things that...

Thank you Jeff. I always appreciate your input. One area where I do have concern is that in a 24/7 environment with thousands of connections , there are a few...

In an environment where you are doing lots of inserts and with a uniqueIdentifier type, first consider that you are not using the 100% fill factor. From there you can...

In an environment where you are doing lots of inserts and with a uniqueIdentifier type, first consider that you are not using the 100% fill factor. From there you can...

"The SQL service frequently locks up without any apparent reason, causing all databases to drop."

What to you mean by locks up? and do you mean the databases drop from the...