Viewing 15 posts - 16 through 30 (of 2,853 total)
Just to add to the advice - I would advise against SELECT * unless it is absolutely necessary. The reason being if the source metadata changes (column added or column...
August 11, 2025 at 2:52 pm
interesting. i generally rdp into that machine and more often than not when i disconnect, ssms is still left running under my creds. let me see if that makes...
August 8, 2025 at 5:30 pm
Another thing it can be that I have seen is if I leave SSMS open and connected to a system for a long period of time, SSMS gets slow. If...
August 7, 2025 at 7:54 pm
As a guess - how much free resources (memory specifically) do you have when it gets into the funk and what is your max memory configuration? I am thinking it...
August 7, 2025 at 5:26 pm
To add to what Thomas Franz said, there are also risks with indexes. In some cases, indexes can hurt SELECT performance. Also, the different types of indexes is a bit...
August 7, 2025 at 5:19 pm
My advice - reach out to your licensing contact as they will be able to help you more than a random forum.
But according to Microsoft:
Client access licenses (CALs) are required...
August 7, 2025 at 2:30 pm
I think log shipping should work. Found a blog post where someone did that with a 60TB database:
And they had basically no downtime!
August 6, 2025 at 10:02 pm
I've not done anything that big before, but there are tools that make failovers nice and easy without the need for AG's. We use DxEnterprise for our failover and it...
August 6, 2025 at 8:05 pm
As a thought - any way you can reduce the database size? Is there some data you could archive to get it to a more manageable size or is all...
August 6, 2025 at 7:42 pm
My opinion, AI is great for handing tasks that are slow and error-prone by users. Hand me a 1 GB log file and ask me to find the problem OR...
August 5, 2025 at 8:10 pm
if don't use linked server, how can I achieve my request ? could you kindly give me some suggestion? thanks!
One way to handle removing linked servers is to handle...
August 5, 2025 at 4:28 pm
I'd start by following the Microsoft advice for troubleshooting this - https://learn.microsoft.com/en-us/troubleshoot/sql/tools/troubleshoot-database-mail-issues
If that doesn't help, then you may want to check your spam folder or outlook rules that may be...
July 31, 2025 at 10:02 pm
I do agree that in place is not the best way to go, but sometimes it is the best of a bad situation. The way my environment is set up,...
July 31, 2025 at 2:59 pm
Mistakes happen - it's how we learn. Plus, systems and/or processes and/or policies should be set up to minimize the chance of mistakes. If a big mistake happens, that means...
July 30, 2025 at 4:14 pm
My opinion, upgrading is pretty safe. If you are concerned, set the compatibility level to 170 150 to keep your databases working like 2019 and without any 2022 features.
I'm slowly...
July 30, 2025 at 2:35 pm
Viewing 15 posts - 16 through 30 (of 2,853 total)