Viewing 15 posts - 1,816 through 1,830 (of 2,917 total)
It depends. If the application has a timeout on the SQL connection configured, then the connection will go away when it is closed or timed out. If the application has...
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 25, 2020 at 7:10 pm
I am fairly certain those are showing the current connections to SQL Server. You can connect to SQL Server and leave your connection idle for days and it is still...
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 25, 2020 at 5:32 pm
As far as I know, SQL Server does not keep historical connection information. You can see current information and it wouldn't be impossible to build up a snapshot system where...
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 25, 2020 at 5:20 pm
First thing I notice is that your statistics look to be out of date with the cci plan.
Second, could you provide an actual execution plan for the rid method? that...
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 25, 2020 at 3:16 pm
I'd be checking your maintenance schedules. Things like statistics updates, index rebuilds, index reorganizations, etc. Or an absolute worst case - flushing any caches.
Since the problem happens around the same...
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 24, 2020 at 5:41 pm
I personally don't use R or Python in SQL Server, but my understanding is that both of these have great analytics and graphing libraries in 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.
June 24, 2020 at 2:20 pm
Do you have some sample data where there are duplicates? With the sample data you provided, the results appear identical to what you had in the screenshot.
If I know some...
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 24, 2020 at 2:11 pm
Unfortunately, the only reply I see is Phil's latest one. The one before that was flagged as SPAM.
But Phil is well known on this forum, so I doubt his reply...
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 23, 2020 at 5:30 pm
As far as I know, there is no magic number to say more than x indexes will impact performance. Having 1 index may impact performance, 2 might, or 100 might...
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 22, 2020 at 9:40 pm
I agree with Thom. I want to add another point that MIGHT be a cause for slowness - memory. If the package is a simple data flow task that just...
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 22, 2020 at 8:39 pm
Can you post the relevant logs or portions of the logs? My expectation is that the logs will give us (and you) a better idea as to what is happening...
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 22, 2020 at 5:29 pm
Looking at your tables, do you have any keys on them? If so, then it is pretty easy to do. If you have no keys on it, then it 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.
June 22, 2020 at 5:03 pm
As a thought - do you have SSRS 2017 installed on that computer already? If memory serves, you cannot have multiple SSRS's installed on a single instance with newer versions...
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 22, 2020 at 3:19 pm
Steve - I'd like to touch on your point of:
support UGs (physical and virtual) - I don't know what goes on here, but I'd like to know. Really, I question...
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 19, 2020 at 9:23 pm
I agree with Phil here. 100%. More than 100% if that was possible!
Originally we had a lot of "one-off" SSIS packages that were created for moving data for a very...
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 19, 2020 at 9:06 pm
Viewing 15 posts - 1,816 through 1,830 (of 2,917 total)