Viewing 15 posts - 1 through 15 (of 1,366 total)
Hi Experts,
Thanks in advance. I am new to SQL. Can you please help me in optimizing the query?
CREATE FUNCTION [dbo].[UDF_GET_REVIEWERS_INFO_FOR_COI](@awardId NUMERIC, @nomineeIds varchar(max),@phaseSettingId NUMERIC_ID) RETURNS TABLE AS RETURN SELECT...
August 19, 2025 at 11:09 am
Good morning,
I've noticed my CDC job running for 17 days. I've noticed it before, but wasn't sure it was an issue. I've checked sys.databases to check the log_reuse_wait_desc to...
August 19, 2025 at 10:27 am
Not sure if this is my misunderstanding or an error in my process:
Create AG1 on server 1 & 2. (2019). Add DB1. Replica are joined, DB1 is synchronised.
Create AG2...
August 19, 2025 at 10:23 am
Hello,
I have a large database about 8 GB. It is in an AG.
I have three replicas (Replica1, Replica2 and Replica3)
Replica1 is Primary and healthy
Replica2 is Secondary and heathy
Replica3 is...
August 19, 2025 at 10:19 am
Hi,
Would it be possible to upgrade from sql server 2012 sp4 to sql server 2022 in one upgrade step, or would it require intermediate upgrades?
Thanks for any recommendations.
Hi Cajun_SQL,
It...
July 10, 2025 at 4:26 am
Hi,
Is it possible to upgrade from sql server 2008 to sql server 2022, considering we have hardware req fulfilled?
Or like we have to upgrade to sql server 2014/16 midway...
July 8, 2025 at 10:19 am
Anyone got any good advice for performance tuning CDC on a Managed Instance?
We are seeing around a 30-35% performance degradation (mainly runtime), with CDC enabled in test.
Done the usual,...
June 13, 2025 at 9:52 am
Hi Team,
Can you someone suggest a few good third part backup tools, with good speed?
The requirement is looking for a tool that should work without affecting db performance, in...
May 6, 2025 at 10:03 am
I'm running some restoration activity as part of a rehearsal to prepare for an actual SQL server upgrade from 2008 to 2022. We're planning to restore the backups taken...
March 13, 2025 at 7:26 am
4 TB SQL backup may take a long time
Have you looked at backup snapshot technologies? Like Veeam / SAN ...
We have Avamar here and we are testing it out?...
March 4, 2025 at 11:35 am
Thank you Jeff, Please find my inline response below.
If those backup drives are on the same system as your SQL Server, you need to move them to a different...
February 27, 2025 at 9:41 am
HTH
Please provide feedback on your progress and solution.
Ofcourse, I am waiting for the next maintenance window or a failover to happen :-D.
January 28, 2025 at 10:32 am
The number of VLFs are to be seen per database and will be handled at startup/recovery time ( of the database, as a step in the startup of the...
January 22, 2025 at 7:51 am
Viewing 15 posts - 1 through 15 (of 1,366 total)