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 2 years, 5 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

Hi Experts,

I ran the below query and for a table I am getting very high writes and its increasing every second. The table here is a master table...

Hi,

Simple question, I know that FileStream is not supported in Azure DB single database or Elastic pools but is it supported in a managed instance?

I've tried to find a...

HI, Here is my issue:

I have 2 SQL 2019 instances and set up 1 linkded server. It works fine in local (remote to the server), but got the error...

Hi Bhuvesh,

In the scripts provided I can see only data & log files , can you share more details on what exactly you trying to achieve?

Are you moving a DB...