Viewing 15 posts - 1,846 through 1,860 (of 2,883 total)
That sounds like a maxdop and cost threshold configuration issue.
But if you execute sp_who2 and look for multiple copies of the same SPID, that'll show you how many threads are...
June 4, 2020 at 3:31 pm
this page has a good writeup on page splits:
https://blog.waynesheffield.com/wayne/archive/2016/10/smart-page-split/
but if you think of it like a phone book, with each page in the phone book holding 8 KB of data,...
June 4, 2020 at 3:22 pm
After the restore completes, are you still seeing those errors? The line:
06/03/2020 17:43:21,spid56,Unknown,The tail of the log for database DATABASE is being rewritten to match the new sector size of...
June 4, 2020 at 2:53 pm
To fix problem number 1 (LEFT or SUBSTRING error), lets look at your query for all cases of LEFT or SUBSTRING. That gives us this small chunk of your code:
June 3, 2020 at 9:50 pm
Maybe I am misunderstanding the problem here, but to me how you describe it is how I expect it to work.
With the second query and second screenshot, you are showing...
June 3, 2020 at 9:25 pm
First, I should note that I have SQL standard, not enterprise and have not done partitioning so my input here may be way out to left field.
I was just reading...
June 3, 2020 at 8:24 pm
Found this post:
where they found that there was a conflict in 2 tables. The recommendation was to install the latest patches, but the user fixed it by deleting the schedule...
June 3, 2020 at 7:13 pm
A server which was created ONLY to host SSRS (created before I started, and at this point I was a good 6 years into being a DBA, so...
June 3, 2020 at 7:00 pm
We do not use LDAPS at my workplace. But, after a quick google I found this post:
https://stackoverflow.com/questions/45224506/how-to-query-ldap-over-ssl-from-sql-server
but it sounds like you already tried that.
Could you post the full error (stripping...
June 3, 2020 at 4:01 pm
My understanding is similar to yours - SQL shouldn't let you run the same job twice at the exact same time. I have tried doing this and it gives me...
June 3, 2020 at 3:17 pm
Not SQL related, but you can do similar things with C# and other .NET languages if you use Visual Studio.
I like doing this when I make an application in C#...
June 3, 2020 at 3:01 pm
I had a much nicer licensing audit that a lot of people I imagine. I was terrified of being audited as I was SURE we were out of compliance but...
June 3, 2020 at 2:33 pm
When is that error thrown? Is it thrown during the database restore or at some other point?
Quick google of the error is being thrown by an AG during a sync...
June 2, 2020 at 8:53 pm
Thanks Pietliden for putting the code in a consumable format without having to jump out to a 3rd party website.
SQL Espo, what have you tried already? Posting what you have...
June 2, 2020 at 5:39 pm
Multiply by 100 prior to doing your last convert. your division (for example) is giving you 0.66666666666666... and you convert that to decimal(10,2), the number is now 0.67. Then you...
June 2, 2020 at 5:17 pm
Viewing 15 posts - 1,846 through 1,860 (of 2,883 total)