Viewing 15 posts - 31 through 45 (of 154 total)
jbalbo I think you are missing an important aspect of database tables when inserting records into a table it makes no difference what order you put them in unless you...
October 5, 2023 at 11:06 pm
The question here is why in first couple of days this error did not occur in the production environment and suddenly it gave this error. and how to trace...
October 5, 2023 at 10:34 pm
I concur with Jeff Moden put the COMMIT inside the IF for if the BEGIN TRAN is inside the IF then having the COMMIT outside the IF is totally meaningless.
Further...
October 5, 2023 at 1:42 am
Okay looking at what you shared here would be a more efficient way of doing it -- although you would need to test the second SELECT to be sure it...
October 4, 2023 at 9:17 pm
A Corollary to what Jeffrey Williams said -- perhaps you might need additional Indexes upon your parent table.
However, copying that table into a temp table simply does just that, it...
October 1, 2023 at 5:22 pm
Nice troubleshooting Jonathan AC Roberts I was unable to test that at the time of my post but great that you did.
October 1, 2023 at 5:10 pm
Firstly please do not take my constructive criticism poorly, as it is meant to help you improve future questions so that you can get quicker answers as well as perhaps...
September 30, 2023 at 6:19 pm
Jo Pattyn why on earth would you want to avoid parallellism as that is in every case that I am aware a majorly good thing that helps a Query complete...
September 30, 2023 at 5:05 pm
Yes thanks Jeff Moden I love it when I can tune into a forum and actually learn something new. Your expertise and your willingness to give it to others for...
September 30, 2023 at 4:54 pm
The ASCII function clearly states it only handles valid ASCII values which are Integer Values and NULL which is a special value unto itself cannot be converted to an Integer...
September 30, 2023 at 4:35 pm
That sounds an awful lot like open source development 😛
Yeah you can even say that perhaps MS made the first semi-open source software on a mega-scale. Except they choose...
September 10, 2023 at 11:37 pm
Between that and the GENERATE_SERIES() defeating Minimal Logging (article coming out on that on the 18th) and the DATETIME rounding issues into the next day that started in 2016...
September 10, 2023 at 7:25 pm
Well hughfconnor that was one of the things I was driving at in the solution I provided as the business logic for that was not clearly defined and would need...
August 16, 2023 at 8:20 am
Yeah that exchange kind of speaks volumes for itself. Being the senior lead database developer in charge of what is going on within a mess of a database because folks...
August 7, 2023 at 8:10 am
@scottpletcher rather than say not to use SET DATEFIRST, perhaps explaining why you feel using it is dangerous, your vague statement does not really counter the documentation stating...
August 3, 2023 at 9:51 pm
Viewing 15 posts - 31 through 45 (of 154 total)