Viewing 15 posts - 1,606 through 1,620 (of 2,917 total)
I feel the pain... My headset (bluetooth) sounds really nice... for the audio output... Bass is a tad high, but I have tools to tweak that. So things sound great...
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.
August 17, 2020 at 3:40 pm
Going with the assumption that this needs to be an application job, I highly doubt a web server is the right approach for this type of work. Even a 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.
August 17, 2020 at 3:17 pm
That is an easy fix - you need to change the JOIN condition in the recursive CTE to include a longer FileID. Your old one was 3 digits, your 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.
August 14, 2020 at 9:46 pm
Does my sample code not handle depths of 4? I just tried it with a depth of 4 and it worked fine.
Do you have some sample data that is 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.
August 14, 2020 at 7:57 pm
I personally have not run into this - my upgrade from pre-2014 to post-2014 went 100% smooth for the ones that did migrate and the ones that we haven't migrated...
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.
August 13, 2020 at 3:55 pm
One thing I've learned from my years in IT and as a DBA and an application developer (I wear a lot of hats) - performance in SQL doesn't degrade unless...
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.
August 13, 2020 at 3:31 pm
You can, but it depends on what you are showing in the datasets. There are some blogs about this, my quick search brought up this one which has good examples...
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.
August 12, 2020 at 6:44 pm
SSRS can only display and do calculations on data that is provided to it. If you want the subtotal and totals, you will need that data pulled into SSRS.
There 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.
August 12, 2020 at 5:55 pm
Personally, what I would recommend is to use the OS that you and your team can support.
If you are responsible for managing the server and you have little to no...
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.
August 12, 2020 at 5:51 pm
My guess as to the slowness - you are doing things row by row and have a large data set to deal with and you are processing the data 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.
August 11, 2020 at 10:29 pm
My expectation - this is a non-issue. Scripting tables across a linked server that changes database technologies is likely to produce weird results. BUT if you want to blame someone...
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.
August 11, 2020 at 8:34 pm
Ok, so what is the web actually running against the SQL database?
If it is starting a SQL job (for example), the job may need tuning.
Since it is not SSIS, 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.
August 11, 2020 at 8:29 pm
How many non-clustered indexes do you have on the table?
The more indexes you have, the more stuff it needs to look at to delete. If you can disable all 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.
August 11, 2020 at 6:18 pm
It depends on what the job is doing. Since memory and CPU don't appear to be the bottleneck (their utilization is low), finding the bottleneck and improving on it would...
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.
August 11, 2020 at 6:12 pm
If you are going with Scott's approach, step 1 of the job would be to start the job you want to monitor. Next, you wait for some period of time...
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.
August 11, 2020 at 5:38 pm
Viewing 15 posts - 1,606 through 1,620 (of 2,917 total)