Viewing 15 posts - 3,331 through 3,345 (of 59,067 total)
Just remember that you'll end up with a rather huge transaction log file on Step 3 and it will take 2-3 times longer if you don't achieve "Minimal Logging".
June 8, 2022 at 3:45 pm
Jeff,
My largest table has 20 million records and uses around 20 gigs but my tempdb maximum size is 192 gigs.
Regards,
That's a rather huge TempDB considering the relatively small size...
June 8, 2022 at 3:42 pm
Thanks Jeff for those pointers. I am basically checking for an extended event trace definition file to track these numbers.
I never used sp_blitz and not sure how it will...
June 8, 2022 at 3:33 pm
Yes it's just an encoding. How could one perform such an encoding without XML? That's the hijacked topic 🙂 As an aside: I associated the encoding with a conversion...
June 7, 2022 at 4:21 pm
Thank you Jeff, for your follow-up!
The entire table might exist or not. The reason for that—versions of the particular app, so the query must be just one but run...
June 7, 2022 at 6:25 am
Sounds like your transaction log being full is putting a stop to replication. There is no need to "shrink" the log file if it is just going to grow...
June 7, 2022 at 6:19 am
Until we know for sure that the left side is absolutely guaranteed to be 4 digits with no leading zeros and the same with the right side with no leading...
June 7, 2022 at 1:40 am
Apologies for the numerous posts. I just find problems like this to be interesting.
I was using literal integers instead of variables before. In previous versions of SQL Server, that used...
June 7, 2022 at 1:33 am
If there's a guaranteed 4 significant digits to the left and no more than 7 digits to the right, this will also work. It still has the issue of being...
June 7, 2022 at 12:50 am
Well blow me down. I took my other post I had here down. The string method Jonathan posted beats even the pure integer math in this case.
Here's the test table...
June 7, 2022 at 12:03 am
Have you actually had to do such a thing where you work?
June 6, 2022 at 10:50 pm
Does the table actually exist and you're just checking to see if the column exists or will the table actually be missing?
In either case, I'm pretty sure that you're going...
June 6, 2022 at 10:47 pm
Here's the code to get the two values as separate integers. I've also included code to concatenate them as a string. I still don't believe that joining them together is...
June 6, 2022 at 10:35 pm
I take it that the zero's between the two obvious parts could be consumed by an increasing value of the right part or will it ALWAYS be 7 digits (no...
June 6, 2022 at 8:37 pm
One area where it seems XML is required is for the conversion/encoding of strings to varbinary base 64. Altho if there's newer way I'd be interested to hear about...
June 6, 2022 at 8:15 pm
Viewing 15 posts - 3,331 through 3,345 (of 59,067 total)