I'm not as old as you are, Rick, but Roger that and ditto that. 😀

I also download at least the latest version of the "ACE" driver/providers so that I don't need to go anywhere near SSIS just to import a spreadsheet.

https://www.microsoft.com/en-us/download/details.aspx?id=54920&irgwc=1

See the following for the list of supported Trace Flags.

https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-traceon-trace-flags-transact-sql

1118 (No longer required but I used to have it on server wide.  I have the equivalent turned on in every...

Why on Earth would you use PoSh to do this?  You have the data in a table already.

https://www.sqlservercentral.com/articles/convert-unix-timestamps-to-date-times-in-sql-server-part1

I saw that and I kept asking myself where the heck the link was.  I have the "nightlight...

From the article:

---

Further, because we’re aging, we’re not ready to embrace all the wonderful new technologies that are clearly superior in every possible way.

I know I responded...

p.s. Read the article at the first link in my signature line below for how to post some readily consumable test data.  It'll help you get a coded answer instead...

No, I won't be limiting the TicketOpenDate for the query.  I may add a month filter to limit TicketOpenDate at a later time.  The initial query will look at...

Yeah, we do index rebuilds quite often but I am not 100% sure. but definitely that could be one of the reasons.

Jeff, I got your point. Could you please...

My two thoughts on things like this continue to be...

1. Change is inevitable.  Change for the better is not.
2. If you want to learn something totally new, then try learning...

Thanks for the article, John.  I'd like to do an experiment with another method.  Can you identify the 3rd party link for where to get the source CSVs from, please?

This is how my table looks except I used random numbers for my values. Some of the dx columns have values and some do not. How about actually showing...

Please see the article at the first link on how to provide some readily consumable test data to help you help people help you.  It also saves on many questions...

700GB log file for a 5TB database?  Have you determined what caused it to grow that large and, if you reduce the size, will it grow to be that large...

Ditto what Frederico said.  You've already identified the problem queries.  Check the execution plans for them and fix them.

I'll also say that if you have to remove data from a...