Viewing 15 posts - 1,396 through 1,410 (of 2,917 total)
My opinion (I do not have SQL Server on Linux installed), I see no reason why you wouldn't be able to do that.
My expectation as to why it isn't 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.
January 20, 2021 at 7:56 pm
To me, I would start by looking at the process that didn't get killed. whatever process 143 was doing, it needed an exclusive lock on pec_prod.dbo.claim and an intent exclusive...
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.
January 19, 2021 at 9:13 pm
What happens if you do that insert on the other server without using the linked server?
The error "Cursor operation conflict" makes me think that there MIGHT be a trigger on...
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.
January 18, 2021 at 3:21 pm
My 2 cents - if you can't change the query, you only have 2 options to improve performance:
1 - reduce the data set (ie archive data)
2 - indexes
My reading of...
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.
January 15, 2021 at 9:57 pm
Welcome to the world of SQL Server.
So a lot of fun things you are jumping into and probably a lot of unexpected headaches. I will try to address things as...
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.
January 15, 2021 at 9:35 pm
Seeing the entire deadlock graph would help. it is not likely that the query is deadlocking itself, but your query and another have a conflict that requires one of them...
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.
January 14, 2021 at 8:23 pm
My approach to this is:
1 - get it set up in a test environment
2 - put the query into a transaction
3 - roll back the transaction on completion.
The above approach...
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.
January 14, 2021 at 7:35 pm
That was an interesting question today! Learned something new!
As a bit of a sidebar, it will also seriously speed up code for things like REPLACE, especially for...
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.
January 14, 2021 at 5:57 pm
Have you checked for memory pressure?
Alternately, is this happening on a regular basis? Like, based on what you are seeing, could it be a scheduled task? I am wondering if...
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.
January 14, 2021 at 2:35 pm
That was an interesting question today! Learned something new!
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.
January 14, 2021 at 2:31 pm
From a cost perspective, it will probably be cheaper to install visual studio on the developer machines rather than getting enterprise/professional licenses for all of the developers so they can...
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.
January 12, 2021 at 7:47 pm
As far as I know, SSIS is going to be complicated to do this. You are basically going to need to build up a custom script in C# (or equivalent)...
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.
January 12, 2021 at 4:58 pm
I think that depends on the tools you have and what you mean by memory and CPU utilization. I expect you are looking for an average load, but looking at...
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.
January 12, 2021 at 4:54 pm
without knowing what you are trying to do on the database, I am not sure what direction to point you in.
But a good starting point would probably be sys.databases. It...
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.
January 11, 2021 at 10:18 pm
Yep. It is called "Data Migration Assistant" and it applies to multiple SQL Server versions, not just 2019.
Something to note, it can be a bit of a resource hog if...
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.
January 11, 2021 at 10:13 pm
Viewing 15 posts - 1,396 through 1,410 (of 2,917 total)