Viewing 15 posts - 1,756 through 1,770 (of 2,917 total)
Thanks Jeffrey! You are right. My query is not going to work due to the comparison on Column1. My query would have only returned rows that had Column3 = MAX(Column3)...
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.
July 7, 2020 at 2:52 pm
I think this may be by design. A normal user generally shouldn't need to run any sys stored procedures as those are more aimed at a DBA.
If you REALLY need...
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.
July 7, 2020 at 2:37 pm
Ken, get well soon!
You need to get to HAL9000! Only 8996 more HAL's to go.
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.
July 7, 2020 at 2:23 pm
My opinion - those are 2 distinct problems. First being searching of Word documents and the second being searching user text stored in MySQL DB. If the word document 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.
July 7, 2020 at 2:15 pm
oh nice. Then it is likely already sorted, so the query I gave SHOULD give you pretty good performance.
My opinion, that is likely the best you will be able to...
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.
July 6, 2020 at 8:54 pm
If the function is just a MAX, I would change the query to be something more like this:
DECALRE @maxValue int;
SELECT @maxValue = MAX(column3)
FROM Schema1.Object2
SELECT Object1.Column1,
...
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.
July 6, 2020 at 8:05 pm
There is always something; it is just what you are willing to do.
Selecting fewer columns can improve performance, removing functions can improve performance, reducing the result set can improve performance.
Fewer...
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.
July 6, 2020 at 7:38 pm
I am assuming you are importing a flat file into SQL Server via SSIS. If so, the limitations I know of are only based on the amount of memory 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.
July 6, 2020 at 7:18 pm
For others who want to help without downloading, here is the query:
USE Database1
set statistics io on;
set statistics time on;
SELECT
Object1.Column1,
Object1.Column2,
Object1.Column3,
Object1.Column4,
Object1.Column5,
Object1.Column6,
Object1.Column7,
Object1.Column8,
Object1.Column9
FROMSchema1.Object2 Object1
INNER JOIN ...
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.
July 6, 2020 at 7:15 pm
Just to add a small little bit to what everyone else said, the user may map to the login with a different name. For example, the user may be named...
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.
July 6, 2020 at 4:06 pm
Joe, some of the stuff you said I agree with, but some of that was a bit uncalled for don't you think? "Perhaps you should read a book?". Looking at...
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.
July 6, 2020 at 3:08 pm
At my workplace, end users are not allowed to connect to the LIVE systems via excel. We don't have any specific rules restricting this, but we advise the analysts 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.
July 3, 2020 at 9:29 pm
As this is a SQL Server forum, you likely wont' get too many replies.
Posting to MySQL or AWS may get you better results, but my guess is that there 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.
July 3, 2020 at 4:29 pm
My opinion is that it depends. How much downtime is acceptable being the biggest question.
Let's say the server completely dies on you one day; it just won't power on anymore. ...
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.
July 2, 2020 at 7:31 pm
You say you have tried things and are looking for answers that are "better than" yours. To avoid us posting identical things than what you already have, could you post...
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.
July 2, 2020 at 7:19 pm
Viewing 15 posts - 1,756 through 1,770 (of 2,917 total)