Viewing 15 posts - 1,711 through 1,725 (of 59,061 total)
Howdy, Grant...
A lot of people won't be able to figure out how to get to this good article to read it because it's missing the clickable title. The icon to...
March 11, 2023 at 3:50 am
@jonathan-2... that will work if "any" of the 3 are present. I'm thinking the OP only wants to exclude if all 3 are present. But, please, let him explain that.
March 11, 2023 at 3:41 am
Based on Group BY ID, I need to verify for each ID we have row exists with Description Apex, SIERRA, BILL.
Do you mean ID's that contain any of those...
March 11, 2023 at 3:38 am
It's basically how you ask ChatGPT questions in a way to get better answers.
That means that all of those people are doomed. 😀 Stop and think about the questions...
March 10, 2023 at 9:43 pm
Jeff, thank you for your kind words. And I always enjoy hearing your words on SSC.
Your wish makes me think: I'd rather be an octogenarian than an oxygenarian. Now...
March 10, 2023 at 9:39 pm
The only problem that the ChatGPT version has is when the first "word" is 8000 characters long or the combination of the first and second words is 8000 characters long. ...
March 10, 2023 at 8:48 pm
Awesome test rig, Jonathan!
Here's another method that I think you'll appreciate performance wise. (didn't see the post above when I posted).
SET STATISTICS TIME,IO...
March 10, 2023 at 7:57 pm
Heh... ChatGPT... when it comes to SQL, it's amazingly "average" because it's drawing on the "average"... which is usually amazingly low bar compared to what most of the denizens of...
March 10, 2023 at 7:21 pm
My 'normal' continues, or maybe it's close to normal. Spring is near, and I've had a few nice afternoons on the patio with my sweet wife for our wine...
March 10, 2023 at 7:00 pm
I had a personally rolled one for statistics I used to use. Then I used, oh gosh, what's her name, used to work for GoDaddy... well anyway, she stopped...
March 10, 2023 at 5:54 pm
I find that the reason why most people poo-poo xp_CmdShell is because they don't actually know how to use it correctly and safely and they also forget that only the...
March 10, 2023 at 5:32 pm
Heh... "Normal". I had to look that word up in the dictionary. 😀 I'm actually pretty happy with "my normal". 😀 It would be extremely boring for most others.
And I...
March 10, 2023 at 5:18 pm
What script do you use to update the statistics?
I wrote my own little dity. Basically, it skips anything that has been rebuilt in the last 22 hours and it's...
March 10, 2023 at 5:09 pm
Thanks....the 2 tables in question are pretty small and have same amount of rows in both UAT & PROD
I've updated the STATISTICS on both tables and waiting for user...
March 10, 2023 at 7:40 am
I want to ensure that my indexes and statistics are optimized on a regular basis.
Obviously, two totally different subjects.
I rebuild stats on a nightly database on two of...
March 10, 2023 at 6:43 am
Viewing 15 posts - 1,711 through 1,725 (of 59,061 total)