Viewing 15 posts - 331 through 345 (of 2,917 total)
To add to what everyone else said, I would not be surprised if it isn't 2 isolated databases involved. What is MORE likely is that a view on database 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.
March 18, 2024 at 2:17 pm
Not essentially a "speed it up" thing, but could you refresh a test instance and run that on the test instance? I am wondering if MAYBE the slowness is due...
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.
March 18, 2024 at 2:11 pm
That screenshot is TINY, but if I am reading it right, you are missing the functions. Have you installed the required modules and are you using the correct powershell version...
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.
March 15, 2024 at 4:59 pm
I agree with Frederico_fonsca here - OPENQUERY is going to give you the best performance as the query runs fully on the remote side. IF you are doing it 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.
March 15, 2024 at 4:07 pm
Just to add to what Ant-Green is saying - if you expose your SQL instance to the internet (ie not behind a firewall), someone is going to try to get...
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.
March 15, 2024 at 3:53 pm
Can you connect using other tools? The error tells you what is wrong though - Visual studio can't see the server. If I had to guess, I would say firewall,...
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.
March 13, 2024 at 8:22 pm
To add to what Frederico_fonseca said, we don't even know what tool you are importing the data to/from. You say "ETL", but is this SSIS? I think so, but not...
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.
March 13, 2024 at 8:18 pm
Just trying to eyeball your deadlock, it looks like the deadlock is caused by a python script. Quick review of the deadlock XML, it kind of looks like you are...
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.
March 11, 2024 at 1:55 pm
I know a lot of discussion has already happened on this, but I wanted to point out that it would be nice to see the actual vs estimated execution plan....
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.
March 11, 2024 at 1:32 pm
As far as I am aware, you can make the SSIS package in newer versions of VS, you just can't deploy IF the version is too new.
For example, I 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.
March 11, 2024 at 1:14 pm
Have you tried connecting by IP instead of server name set up in the hosts file? I am wondering if SQL Server Engine doesn't "trust" the hosts file and is...
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.
March 4, 2024 at 5:49 pm
One thing to point out though about the hashing approach and indexing on it though - is that index useful? You likely are not searching by the hash and are...
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.
March 4, 2024 at 5:45 pm
To add to this, settings for parallelism are not some "magic" number that can be applied across any environment. If it could be recommended with little to no information, then...
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.
February 26, 2024 at 7:14 pm
Yep. Lets say you are doing an update on a table or insert which requires an exclusive lock on the table. Having the query go parallel creates self-blocking as 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.
February 23, 2024 at 6:08 pm
Another thing - is there a query hint to put the MAXDOP to another value? I know you can set that at the instance level, database level, and query (or...
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.
February 15, 2024 at 6:38 pm
Viewing 15 posts - 331 through 345 (of 2,917 total)