Viewing 15 posts - 1,756 through 1,770 (of 2,919 total)
I have never used the tool azcopy.exe before, but as a thought, does your SQL Server Agent account have permission to the Azure site and have access to the files...
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 3:53 pm
My advice is to not do an in-place upgrade. The benefits of an in-place upgrade are that you don't need to change any connection strings in your applications and 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.
July 7, 2020 at 3:00 pm
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
Viewing 15 posts - 1,756 through 1,770 (of 2,919 total)