Viewing 15 posts - 1,396 through 1,410 (of 59,066 total)
Thank you for the reply, yet I think it will not work if the reason column, as I mentioned in my original request, will have several concatenated reasons.
Do those...
May 30, 2023 at 6:33 pm
Just to be sure, a LOG or History or Audit or Temporal table should never have any triggers or constraints on it that evaluates data. Certainly, it should not be...
May 28, 2023 at 4:22 pm
Having supported a COBOL application for over 10 years, COBOL is a good language. Yes, it is wordy compared to modern programming languages, but that doesn't mean it...
May 28, 2023 at 4:15 pm
I cannot give DDL and sample data. Only that small part pretty much that I gave in the first message and yes, you are correct, I need to write...
May 26, 2023 at 9:02 pm
@Eirikur,
I keep looking at your timing results. You say the following...
Given the performance improvements gained by removing one REVERSE instance, I think we got some opportunities for improvement and more...
May 26, 2023 at 3:38 am
p.s. And, I agree... MS seems to follow a policy of "patch it until it breaks". 🙁 They're "It just runs faster" brag in 2016 broke some serious stuff for...
May 24, 2023 at 6:11 pm
@kevin Gill
EDIT: Sorry... I didn't read your last post where you said you've already tried the following.
The issue is, almost certainly, the changes they made to the Cardinality Estimator in...
May 24, 2023 at 5:59 pm
If you'd take the time to convert the data for BaseTable_A into a "Readily Consumable" format (please see the article at the first link in my signature line below...
May 24, 2023 at 2:29 am
If you'd take the time to convert the data for BaseTable_A into a "Readily Consumable" format (please see the article at the first link in my signature line below for...
May 23, 2023 at 5:01 pm
Thanks People! I was running out of time, so I had to drop the idea to do it using SQL.
What did you use instead?
May 23, 2023 at 3:00 am
I find that a serious percentage of front-ends qualify as "empathetic - em" design. For example, long gone are the days when the menu remained visible when scrolling down or...
May 22, 2023 at 6:03 pm
Heh... "Just because you can do something in Python, doesn't mean you should". 😉
May 21, 2023 at 6:53 pm
Okay if I understood your last post I will say -- (1) I do not make sarcastic comments without including an 😉 to let you know I am not...
May 21, 2023 at 6:12 pm
No Jeff Moden I did not state that SQL was a dinosaur at all, I think I basically referred to others doing so with dynotopic languages such as Cobol....
May 21, 2023 at 1:06 am
As you said, I'm making sure of clarity. 🙂
With that, I'll say that you've just repeated yourself. You're insisting that SQL is a dinosaur here and the its technology is...
May 20, 2023 at 3:13 am
Viewing 15 posts - 1,396 through 1,410 (of 59,066 total)