Sorry missed the attachment. Uploaded the...

Thanks all the experts.Sorry I missed the attachment. Please have a look at the attached.

Seems like the issue is due to parallelism, Any experts here can give more insight.

Thanks...

The setup is: OS - Win Server 2022 & MSSQL - SQL Server 2022 AlwaysOn Availability Groups are enabled on two (primary + secondary) replicas and use WSFC. Several availability...

Very interesting topic Steve. What I have observed very common is the data type mismatch in LINQ queries which causes the queries to do Table scan instead of seek even...

I am trying to mirror a TDE Encrypted Database. (SQL 2019). When I try to start mirroring with the GUI it says "Database not configured for mirroring". Same if...

Thanks Emperor100 but my question is about the open transaction .

The query is from Informatica tool which is causing this issue. Anyone have any idea why this is happening.

• This reply was modified 1 year, 8 months ago by  VastSQL.

What would you usually be creating a maintenance plan to do?

DBCC CHECKDB

Database backups

Index maintenance

So doing a quick google search (other providers available) “do I need to run dbcc checkdb...

Awaiting expert opinion.

From your post I believe you are mentioning about job output file. Do you have the output file in place? Create a file with the mentioned name in SQL job...

Anyone experienced on migrating VLDB from 2014 to 2019

Thanks Grant for the reply,

how can we identify which connection it is? it is not resolved yet .

Thanks Federico & Jeff ,

As mentioned in the note on-premise need sysadmin , the initial load worked with minimum permission they mentioned but not the incremental. Threw below errro.

HTTP response...

Thanks everyone