Viewing 15 posts - 211 through 225 (of 2,917 total)
how much memory does the SERVER have in total and how much is dedicated to SQL Server? If I am reading your question correctly, you have 300 GB RAM 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.
August 15, 2024 at 8:09 pm
As someone who has had (and currently has) VPN access on their phone AND RDP access on my phone, I do not recommend it. While it is possible, it 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.
August 9, 2024 at 9:07 pm
Just to add to what Jo Pattyn said, there are a lot of reasons why a thing can be fast in SSMS and slow in applications. You could have some...
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.
August 9, 2024 at 8:58 pm
Just my 2 cents on this - I wouldn't rely on "ping". PING will only tell you that the computer is online assuming ICMP isn't disabled at the firewall. 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.
August 9, 2024 at 8:42 pm
Another thing to note - SQL Server, with the default configuration, will use up to 2 PB of memory or whatever is available in the system. In order to reduce...
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 31, 2024 at 8:33 pm
Looking at the docs for the Microsoft Oracle Connector, you can use LDAP for authentication - https://learn.microsoft.com/en-us/sql/integration-services/data-flow/oracle-connection-manager?view=sql-server-ver16.
It states that you can pick to use Windows Authentication or Oracle Authentication. Windows...
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 30, 2024 at 8:56 pm
thx Brian. Unfortunately you are seeing a mention about the speed issue out of context. I was just trying to find COMMIT size here like i believe we used...
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 29, 2024 at 3:27 pm
One thing to note about things being slower when run over VPN in SSIS, slower than where? Slower than the exact same workstation (laptop/desktop) being on site OR slower than...
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 26, 2024 at 9:29 pm
I have not tested this script, but what about this link:
Eitan Blumin has a script that he claims works to move logins and users across different systems. NOTE I 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.
July 26, 2024 at 2:50 pm
I too am curious how the project is going or went. I definitely wasn't trying to say "don't do it", I was just trying to say to be careful with...
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 26, 2024 at 2:39 pm
I wonder if it is impatience on Steve Jones's part OR a configuration thing? I can't remember if the SQL services are set to auto-restart on unexpected stop or 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 25, 2024 at 10:04 pm
Index Optimization: Review and optimize indexes to ensure they complement the new primary key and do not degrade performance. Data Integrity Checks: Implement regular checks to ensure data integrity,...
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 25, 2024 at 2:17 pm
My advice is actually going to be the opposite of a lot of others here - I wouldn't add any columns to the table or change the structure. The reason...
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 24, 2024 at 8:45 pm
Just my 2 cents - shrinking any database is not a good idea. The DB grew to that size for a reason, and tempdb grew likely due to queries being...
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 24, 2024 at 8:22 pm
Quick google, it looks like failback isn't something that happens with AG's. It is something you can set up, but it's not a setting in the AG. So when 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.
July 19, 2024 at 5:44 pm
Viewing 15 posts - 211 through 225 (of 2,917 total)