We don't use GIT where I work.  I have no need of GIT outside of work.  Until one of those change, I have no need to learn GIT.

I have a...

I'll also suggest that if you're using the Enterprise Edition of 2022, then having only 16GB of Ram isn't healthy.  The reason why your CPUs may be screaming is because...

Why?  In the long run, it's going to be less expensive and less worrisome to buy one, which will also take into...

You have 15 rows that got expanded to 24 and you say you have 30 million original rows, which would be expanded to 48 million rows according the 24/15 ratio...

All,

Thank you for your replies and suggestions. Sorry I haven't been back to this topic, I've had some other unplanned things to sort out. When I get back to...

Step 1 would be to stop doing the re-indexing.  Chances are that you're actually causing more damage than you're fixing especially if your using REORGANIZE or the old supposed 5/30...

I read a wonderful book "A man called Ove" filmed as "A man called Otto" starring Tom Hanks.  Read the book.  Ove is the GOAT of cranky curmudgeons.  The...

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