No data returned . I second Jeff

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...

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...

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...

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...

Hi Cajun_SQL,

It...

• This reply was modified 2 months, 2 weeks ago by VastSQL.

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...

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,...

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...

Congratulations  Grant

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...

We have Avamar here and we are testing it out?...

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...

Ofcourse, I am waiting for the next maintenance window or a failover to happen :-D.

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...