Viewing 15 posts - 1,951 through 1,965 (of 2,917 total)
My only thought with this if it is a problem on the DATABASE side is something is going goofy with some data type conversions. Such as converting VARCHAR to NVARCHAR,...
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 13, 2020 at 4:25 pm
If they know which switch specifically is having the issues (which is likely), it might be a configuration issue. Especially if you were upgrading things. Now, I am not a...
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 12, 2020 at 7:19 pm
The official docs from Microsoft state it uses that one. See:
And the table towards the end states that SQL Server (default) uses "Microsoft SQL Server Native Client OLE DB Provider". ...
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 12, 2020 at 5:18 pm
Hopefully fixing the network issues helps resolve the problem. My expectation is still that it will.
Packet discards can be tricky to diagnose the problem, but it could be caused by...
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 12, 2020 at 5:04 pm
To me it sounds like permissions were set wrong likely when fixing the orphan users OR when copying the logins and roles over.
If you still have the 2016 instance around,...
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 12, 2020 at 4:15 pm
This is an easy one - if you pick SQLNCLI for the provier, it will use the SQLNCLI driver. SQLNCLI is the SQL Server Native Client driver.
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 12, 2020 at 3:57 pm
My opinion is to give them least permission possible for them to do their job but also that they accept responsibility for permissions that they claim to require. For example,...
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 12, 2020 at 3:54 pm
To add to Erland Sommarskog's reply, adding indexes could make things worse too. Not likely to make things worse in terms of memory pressure, but increased disk I/O, larger databases,...
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 11, 2020 at 5:00 pm
Without seeing the script, that is a difficult thing to debug.
My guess is it is not hanging connecting to SQL as that should time out, not just sit hung.
First thing...
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 8, 2020 at 9:40 pm
So I did a quick test of this by running the following:
DECLARE @test NVARCHAR(20) = '2225504600042'
SELECT CAST(DECRYPTBYPASSPHRASE('a test phrase!',ENCRYPTBYPASSPHRASE('a test phrase!',@test)) AS NVARCHAR(20))
SELECT CAST(DECRYPTBYPASSPHRASE('a test phrase!',ENCRYPTBYPASSPHRASE('a test...
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 8, 2020 at 9:28 pm
To add to Jeffrey's response - the client data may have a newline character in it as well.
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 8, 2020 at 4:30 pm
If SSIS is your only option, then you are going to need either some 3rd party tool that allows for editing the Excel OR you are going to need to...
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 8, 2020 at 3:35 pm
Just so I understand what you are asking, you want to know if the following will be counted as 7, 30, 60, 90 and 180:
Insert INto #test1...
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 7, 2020 at 4:32 pm
Looking at the execution plan, the slow operation is pulling the 5 million rows from the Contacts table into memory. It is taking over 40 seconds to pull the 5...
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 7, 2020 at 3:48 pm
I may be mistaken but I am pretty sure what you are asking for does not exist.
If it did exist, I can't imagine the performance hit that would cause in...
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 6, 2020 at 7:20 pm
Viewing 15 posts - 1,951 through 1,965 (of 2,917 total)