Viewing 15 posts - 811 through 825 (of 2,917 total)
Looking at your tables, I don't see how you relate "Products" to an opportunity or order.
I WAS going to say that you could related them by ID on Products and...
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.
November 26, 2021 at 5:07 pm
It might run without issues for you, but it is not a supported configuration. A windows update OR a SQL update could break the SQL instance on that server.
If 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.
November 26, 2021 at 3:40 pm
I see this posted on a lot of other sites and the solution is pretty easy - don't add HUGE columns to a nonclustered index. You need to shrink the...
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.
November 26, 2021 at 3:24 pm
Another thing to note - parallel queries MAY not be what you actually want. Depending on the query, it may not make sense for it to run in parallel. I've...
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.
November 26, 2021 at 3:00 pm
Can they select multiple offices or fol_num's? If so, then it gets a lot more challenging, but if not, then it should be something like this:
AND (OFFC_CODE...
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.
November 26, 2021 at 2:40 pm
Could you post the DDL for Opportunities as well? You posted products twice and then orders.
But looking at that, your orders table has no way to related to products 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.
November 26, 2021 at 2:14 pm
I am just giving my suggestions. My opinion, I would upgrade the server to have the same or more resources than the current server. I would also do database administration,
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.
November 26, 2021 at 2:08 pm
If it was me, I would want the game server to have maximum uptime. Downtime means unhappy customers, no?
If I was a customer for a game and the server went...
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.
November 25, 2021 at 10:06 pm
Zip file is literally the same concern I had initially - I don't download files from unknown sources.
Posting the DDL to the forum will get you better responses to your...
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.
November 25, 2021 at 9:56 pm
I can't speak to all of this as I don't use replication and haven't set it up or seen that problem before, but I am curious what you mean 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.
November 25, 2021 at 7:15 pm
I have not downloaded the files (as I don't generally download files from random people on the internet), but I don't think you are going to get much response with...
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.
November 25, 2021 at 7:10 pm
Personally, I don't think my answer was any better than Steve's. I think his answer was probably just as "correct" as mine.
But to address your concern about needing to add...
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.
November 25, 2021 at 6:56 pm
I agree with Steve here - why would you want to avoid the JOIN? Put a good index on it and you should be good to go.
As an alternate 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.
November 25, 2021 at 6:08 pm
My opinion - I think it really depends on what you need and what growth looks like.
I would personally put the data and log files on different disks if 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.
November 25, 2021 at 5:03 pm
With most SQL related things, I try to avoid the wizards. I find that while they may work, it usually ends up making things in a way I don't want...
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.
November 24, 2021 at 9:44 pm
Viewing 15 posts - 811 through 825 (of 2,917 total)