Viewing 15 posts - 1,471 through 1,485 (of 2,917 total)
You missed putting a checkmark in the error.jpg. Select "MSSQLSERVER" and it should install the update for 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.
December 3, 2020 at 9:23 pm
My advice - contact your license vendor. They will be able to provide you the best bang for your buck and the best advice about what licenses you actually need.
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.
December 1, 2020 at 8:24 pm
This looks like an easy one to me - Z:\ is mapped for you, not mapped for all users on the server. So the SQL Agent service account doesn't 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.
December 1, 2020 at 2:14 pm
I think that is a very per-use case question.
For example, the cost to host a data warehouse is going to be different than a highly OLTP workload.
And there are 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.
November 30, 2020 at 9:48 pm
If I am understanding you correctly, you want to know the second largest record. If so, one way you could do this is to do a nested SELECT TOP query. ...
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 27, 2020 at 6:50 pm
From my understanding both IDX1 and IDX2 would use the exact same space. They are holding the exact same data, just in potentially a different order.
If there is any compression...
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 27, 2020 at 2:10 pm
I think I can help with that one.
IDX1 would have the 3 columns with the data ordered by OrderID, then ItemID, and finally Status. If there were more columns 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, 2020 at 3:45 pm
Looks like someone asked about this on the MSDN forums and got a few answers:
The important bits from the above forum post (the whole thing is a good read mind...
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, 2020 at 5:06 pm
Alternate to triggers, but similar idea, you could implement CDC (change data capture).
If the database table is for a custom-built app, you could also implement audit history like that 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.
November 24, 2020 at 7:29 pm
How many rows are in the table?
I am pretty sure that your WHERE clause is the problem, not the ROW_NUMBER portion. The query, without the WHERE doesn't need to do...
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, 2020 at 3:53 pm
If you load up extended events or profiler, you can see what is being run against the database.
My guess (without seeing anything) is that your shared dataset doesn't have 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 24, 2020 at 3:44 pm
Just to confirm - you don't have any triggers on the table, right? Those can cause all sorts of surprises like 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.
November 20, 2020 at 9:42 pm
William - to address both replies (Jeffery and sterling3721, correct me if I am misrepresenting):
1 - the new driver MAY have some optimizations in it that cause it to give...
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 19, 2020 at 10:11 pm
My guess - your queries don't need to use all of the cores OR your SQL isn't configured to use all of the cores when going parallel... which is best...
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 19, 2020 at 6:04 pm
I imagine you could build up a DLL that could handle it and do some magic on the SQL side, but it is not going to be a quick operation.
Alternately,...
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 19, 2020 at 6:01 pm
Viewing 15 posts - 1,471 through 1,485 (of 2,917 total)