Viewing 15 posts - 1,876 through 1,890 (of 59,067 total)
FWIW, Jeff, it would be great to see a list of common SQL problems that people ought to be able to solve. I'd add in
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2023 at 7:40 pm
Trust me, I don’t use format specifically because of your previous remarks. I changed as little as possible to illustrate a point.
Ah... now I understand. Heh... I thought "WTH? ...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2023 at 3:38 am
Thanks Jeff!
Hey wait...So format not so great? Googling now...
Don't "Google It". Most people don't have a clue about it. Go read the article I provided the link for. It...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2023 at 3:34 am
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2023 at 3:30 am
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....
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2023 at 3:05 am
Crud... forum software lost my page on page 2... "bumping" that page with this post to get it to show up.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2023 at 2:52 am
I'm curious... has anyone checked to see if any of that 17TB can be archived and moved out of the main table?
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2023 at 2:49 am
@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...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2023 at 2:22 am
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2023 at 2:05 am
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2023 at 1:33 am
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2023 at 1:23 am
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 16, 2023 at 1:15 am
You are at the edge of a cliff. I strongly recommend you turn around and go another way.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 15, 2023 at 9:37 pm
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 15, 2023 at 9:02 pm
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...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 15, 2023 at 8:56 pm
Viewing 15 posts - 1,876 through 1,890 (of 59,067 total)