Viewing 15 posts - 76 through 90 (of 55,829 total)
Hi All,
I have the below query , have set datefirst as Sunday (7), but here i am getting week 52 for Sunday and Week 53 for Monday. I am...
June 10, 2022 at 10:11 pm
Focus first on logical I/Os, as that's usually the culprit one way or another.
You just re-stated exactly the first line of what I wrote in an earlier...
June 10, 2022 at 9:03 pm
I considered submitting a request asking for a way to suppress the dark mode request.
I actually have to use DATEDIFF_BIG. The fact they couldn't be bothered to implement the...
June 10, 2022 at 3:45 pm
Or run the stored procedure yourself and email them the results in a spreadsheet.
June 8, 2022 at 5:29 pm
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...
June 8, 2022 at 5:20 pm
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
Viewing 15 posts - 76 through 90 (of 55,829 total)