Viewing 15 posts - 1,891 through 1,905 (of 2,919 total)
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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#...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 2, 2020 at 5:17 pm
Looking at your color chart and the way it is ordering it, to me it looks like you are ordering by region (North America, Europe, Pacific) first and by the...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 2, 2020 at 4:38 pm
I am not aware of any tools that do this automatically for you, but that doesn't mean there are not any.
Where I work, we don't actively monitor for things like...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 2, 2020 at 4:31 pm
I know we use SQL Aliases at my work and they can be a pain. They are nice once they are set up and working, but what if a developer...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 29, 2020 at 9:04 pm
Quick check on your query, and if you look at the 3rd parameter to Substring (the LENGTH portion) you have this:
LEN(output_response_xml) - LEN(LEFT(output_response_xml,
CHARINDEX ('>Thank you', output_response_xml)))...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 29, 2020 at 8:46 pm
To add to Steve's comment, there is more overhead than just the dataype overhead on a row. On top of the overhead by VARCHAR and NVARCHAR, you also have the...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 29, 2020 at 6:16 pm
When I run your query with the date set to 21/05/20, the WEend Raised - Sund is the 24th and the Thursday one is the 21st. Does this not match...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 29, 2020 at 5:39 pm
If you have the Russian language installed in Visual Studio with SSMS version 18.5, it lets you pick that from the settings. I expect it is similar with SSMS 13. ...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 28, 2020 at 6:26 pm
Oh, it didn't come out wrong, I was just admitting that someone on here (ie me) with a lot of posts and been a DBA for nearly 10 years and...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 26, 2020 at 8:46 pm
To add to Jeff's reply, best practice is not always how you should set things up either. Best practice is to use Windows Authentication and not use mixed mode. I...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 26, 2020 at 7:42 pm
Viewing 15 posts - 1,891 through 1,905 (of 2,919 total)