Viewing 15 posts - 91 through 105 (of 1,414 total)
More people need to know about the method that Dave showed in this article.
On modern machines, we still get 3 orders of magnitude difference in CPU and Duration (shown...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 7, 2024 at 1:37 am
I did? I don't remember... I've gotten old enough where I think my harddrive is full and, every time I learn something new, either something else in my mind...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 7, 2024 at 1:23 am
Maybe its time not just to change the Article title but a whole curated collection of "Techniques that have stood the test of time".
It would be interesting to see...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 5, 2024 at 2:56 pm
I assume SQL 2019 for David, but I do think it's hard to regression test. I don't know how many of us have a decent set of things to...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 2, 2024 at 2:54 pm
Maybe split twice using an ordinal string splitter. If there's more than 1 (www.domin.org)'s this would split them all. Splitter is available at this link
DROP TABLE...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 31, 2024 at 4:16 pm
I too am curious how the project is going or went. I definitely wasn't trying to say "don't do it", I was just trying to say to be careful...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 31, 2024 at 3:06 pm
Ha, a haunting could be a good thing 🙂
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 30, 2024 at 7:53 pm
This sounds like an interesting project and I'm wondering how it turned out. Mr. Brian Gale made good points but there are workable solutions around. Some backend developers are web...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 26, 2024 at 1:17 pm
That makes sense. I was going to ask if maybe another script runs at the same time. Afaik processing-wise, the IF condition and the ALTER TABLE statement are 2 separate...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 23, 2024 at 12:56 pm
Thank you but I didn't find the code of fnTally on the link. I also didn't understand how to use log/exp functions to solve this task.
Regarding the use of...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 18, 2024 at 3:56 pm
according to the rules of school mathematics, we bring to a common denominator
How to calculate the product of all of the denominators for each group? Why doesn't...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 18, 2024 at 12:48 pm
The larger query I have has many fields with converts etc. so I am trying not to add the CustomerId to the nested query to get the sum somehow...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 16, 2024 at 6:16 pm
Assuming the parts to be split are: 1) the sentence on the left, and 2) the single string on the right. It appears after the initial 50 character split of...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 3, 2024 at 9:35 pm
In Visual Studio working with git (and GitHub, Gitlab, etc.) seems more streamlined and user friendly. SSMS clunky. For almost everything SQL Server related I use VS but still have...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 1, 2024 at 1:36 pm
Maybe you could try OFFSET and FETCH NEXT on the righthand side of OUTER APPLY
declare
@nth_from_top int=2,
@nth_from_bot ...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 15, 2024 at 11:48 am
Viewing 15 posts - 91 through 105 (of 1,414 total)