Don't "Google It".  Most people don't have a clue about it.  Go read the article I provided the link for.  It...

Also, what would you folks partition the table on? The reason I ask that is that I DO have a partitioned table.  It's only about 2TB with 10 years of...

Heh... Some of the people I've had to work with in the past seem to make a pretty good living at "If it ain't broke, fix it until is" mantra....

Crud... forum software lost my page on page 2... "bumping" that page with this post to get it to show up.

I'm curious... has anyone checked to see if any of that 17TB can be archived and moved out of the main table?

@Wecks ...

Getting back to the subject and with the understanding that I try to anticipate the proverbial "next question" from my users, here's what I'd do along with some documentation...

BTW and just to clarify, I'm damned impressed with what they've been able to get ChatGPT to do.  The technology behind all of that is mind boggling .  My biggest...

Ok... I'm playing with a copy of the Person.Person table from a copy of the Adventure Works database.  I created 3 "scratch" tables, one for each name column, and populated...

You can probably get a significant boost to performance by removing FORMAT and converting those JOINS to a single CROSS APPLY.

It appears you are looking up the anonymized user...

Heh... Ed... as Jeffrey Williams also recommended, my sincere and very friendly recommendation is that you stop using FORMAT.  It's 17 times slower that just about any other rabbit you...

You are at the edge of a cliff.  I strongly recommend you turn around and go another way.

Heh... I did that with the count 1 to a million thing.  IIRC, I posted that little gem that said the rCTE that it created (which I also told it...

Thanks for taking the time to do these experiments, Jonathan.

The reason it got the Zip right is because it's in quotes.  You also had to realize its mistakes...

And, in the process of making the primary key, it made yet another mistake (at least according to my personal standards).  If it's a #TempTable, then never name the PK...

Thanks for taking the time to do these experiments, Jonathan.

The reason it got the Zip right is because it's in quotes.  You also had to realize its mistakes on the...