Viewing 15 posts - 91 through 105 (of 1,419 total)
Begin tran of stp A
Stp B - Insert record in table 1 --> fetch cross DB data --> insert records in table 2 --> insert records in table 3...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
September 11, 2024 at 4:04 pm
What is meant by more call dates and edge cases? Does each [Call Date Start Date] always get split into 2 rows? [Call Date Start Date] is an unfortunate name...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
September 1, 2024 at 10:59 pm
This topic has kept working away in the back of my mind. It's made me wonder what it would actually take to set up a really good 'set based' backend...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 22, 2024 at 7:23 pm
If you alter the collation at the database level it can have a negative impact on many, many things including query results, query performance, backups, indexes, data integrity, and can...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 13, 2024 at 3:39 pm
Well I wouldn't want to make any recommendations in this regard. Changing collation on an entire db could cause major issues. If possible maybe set up a new instance with...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 12, 2024 at 6:49 pm
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
Viewing 15 posts - 91 through 105 (of 1,419 total)