Viewing 15 posts - 1,771 through 1,785 (of 2,917 total)
Also, my brain was thinking about that wrong. What DinoRS put is correct in that "Or in other words: Show only results where you have more than one resultset available.". ...
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 5:58 pm
Does this need to be in SQL 2008? Solutions in newer SQL versions make this a lot easier.
EDIT - if this NEEDS to be in 2008, I did this 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.
July 2, 2020 at 5:45 pm
DinoRS, if I am reading that query correctly, isn't it saying "show only results where you have less than 1 result set available" not "more"?
The WHERE clause is saying "WHERE...
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 3:37 pm
So converting this I am a bit rusty on Oracle, but I think this is going to be similar (although not 100% certain as I have no sample data or...
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.
June 30, 2020 at 7:26 pm
If you'd like more information on indexes, I highly recommend Kendra Little's blog:
https://sqlworkbooks.com/blog/
Kendra is my "go-to" person for indexes!
Brent Ozar has a blog post on it with Kendra Little too:
https://www.brentozar.com/archive/2011/09/kendra-little-explains-how-design-smarter-indexes/
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.
June 30, 2020 at 6:24 pm
Close... My expectation is it isn't taking precedence for one over the other, it is configured to use one over the other.
When SQL was installed originally on the old server,...
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.
June 30, 2020 at 6:20 pm
I am in a similar boat and have created my own "wishlist" as I've started calling it as it is hard to get buy-in from non-technical people. But I'll try...
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.
June 30, 2020 at 6:10 pm
Adding non-clustered indexes depends on the query being executed. Generally, you want to look at the WHERE clause or the ORDER BY clause and anything those are filtering on will...
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.
June 30, 2020 at 5:05 pm
Yep, I agree with you Jonathan AC Roberts, but what if the number of columns is dynamic? With version 1 it has 3, version 2 has 2, version 3 has...
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.
June 30, 2020 at 4:54 pm
Not sure that an index will help anything since there is no WHERE clause or ORDER BY. No matter what index you put on there, it is going to be...
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.
June 30, 2020 at 3:47 pm
It depends. Are you needing to change who it connects as? Are you needing RPC?
My advice, try it out. Make the linked server and see if it works 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.
June 30, 2020 at 3:20 pm
On top of the SQL checks, I would be doing a chkdsk on the system as well. Don't want to find out that the physical disk (OS and SQL disks)...
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.
June 30, 2020 at 2:59 pm
I think you are mixing some things up and getting confused. A LOGIN FAILED message in the log means that a login was attempted but was not successful. The CLIENT...
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.
June 30, 2020 at 2:51 pm
That bit of code looks fine to me. What I'd recommend is posting an execution plan. That will likely be the best bet to figure out why it is slow.
How...
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.
June 30, 2020 at 2:43 pm
Another reason for SQL Server Agent issues is if you are running SQL Express. SQL Express doesn't support SQL Agent.
But, as John Mitchell suggests, check the logs. Also, check 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.
June 30, 2020 at 2:29 pm
Viewing 15 posts - 1,771 through 1,785 (of 2,917 total)