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...

I do wonder

WHEN order_phone = ' ' , what happens if the value is '   ' (3 spaces) ? The LEN function will still give you zero so that is...

One thing about the CHOOSE function is that it seems to provide a tempting way to avoid having a normalised database with its lookup tables. I would be picky about...

Jeff. I'll take a crack at your question:

In your example, are you assuming the date column is indexed and would be used?  What if that is not the...