Viewing 15 posts - 1,711 through 1,725 (of 59,066 total)
Can you share your script?
Attached. Again, I'm very aggressive in the code. If the RowModCtr > 0, then I rebuild the stats. You can certain modify that based on...
March 11, 2023 at 7:10 am
Ugh! Shrinking. It does "index inversion", which is one form of fragmentation that really does hammer performance into the ground. That's why I use the "Swap'n'Drop" method on a lot...
March 11, 2023 at 6:40 am
It doesn't close any "security hole". Only the people that can enable it can use it. Turning it off won't prevent that.
As to your "access denied" error, where is the...
March 11, 2023 at 5:30 am
As for certification, just remember that certification is neither necessary, nor sufficient, for someone to be proficient in their work.
+1000!
March 11, 2023 at 5:20 am
If their plan fails, they can always go back to tipping Dogecoin or peddling courses on how to get rich quick by buying cheap stuff on AliBaba and reselling...
March 11, 2023 at 5:15 am
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
Viewing 15 posts - 1,711 through 1,725 (of 59,066 total)