Viewing 15 posts - 241 through 255 (of 2,917 total)
Have you checked the official docs:
From there you can see what User Scans is showing you - Number of scans by user queries that did not use 'seek' predicate. So...
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 17, 2024 at 5:52 pm
I would start by not following the news from Fox, but that's just a personal bias against Fox News. I would check tech news sites like the register (for example)...
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 17, 2024 at 5:41 pm
The other thing that helps is once you do the presentation at least once, you get a feel for what parts engaged the audience and what parts were boring 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.
June 17, 2024 at 5:29 pm
The way things are set up in my environment, IT doesn't let me auto-generate my SPN's. I can't even make the SPN's. I need to put in a support request...
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 14, 2024 at 9:58 pm
Have you tried googling the error? There are a lot of pages on google with similar errors such as this one:
https://dba.stackexchange.com/questions/188833/sql-linked-server-returning-error-suddenly-upon-query
In that scenario, the problem was a faulty NIC.
I recommend...
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 14, 2024 at 8:34 pm
I may be mistaken but I am pretty sure that the error "The specified network name is no longer available" means that your computer lost access to the server for...
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 14, 2024 at 8:30 pm
Just to add, data manipulation operations (INSERT, UPDATE, and DELETE) on a table need to modify most (all?) indexes on the table. So adding indexes to improve performance of deletes...
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.
May 30, 2024 at 5:25 pm
Apologies for the confusions caused . I am planning to set the execution timeout for all queries that I will be running in SSMS. My goal is to stop...
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.
May 30, 2024 at 2:56 pm
I think the problem is that you are trying to do something that doesn't make sense. The timeouts are configured on a session by session basis, not on an instance...
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.
May 27, 2024 at 3:33 pm
Sorry, been traveling, but to me, I'd say there are a few big things and then a whole lot of small ones.
Biggies
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.
May 24, 2024 at 9:49 pm
I agree with you Steve. Presenting is terrifying and also fun. My first presentation I did was actually as a guest presenter at a university course where the professor had...
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.
May 24, 2024 at 2:56 pm
What I'm seriously miffed about is that no one at Redgate seems aware nor gives a damn about these forums. Apparently even Steve has zero pull with them.
Two short...
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.
May 24, 2024 at 2:38 pm
The trick to solving this problem is to make getting into your software EASY and getting out impossible. One cloud CRM tool we had bought into years back helped us...
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.
May 23, 2024 at 8:27 pm
CDC (change data capture) will track changes on a table, but it can be messy if you have a lot of data that changes, but how you describe it sounds...
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.
May 22, 2024 at 5:55 pm
Just a little FYI too - when hiring a consultant, it never hurts to check what the consultant is an expert in. If you hire a consultant to evaluate 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.
May 22, 2024 at 3:32 pm
Viewing 15 posts - 241 through 255 (of 2,917 total)