After doing work from home for several months I  purchased a new professional office chair. That really changed wfh for me. At the office I had 3 screens, at home...

You have 2 left join statements for BBI$Item ledger entry.

I would take the second reference out

Change your where clause to

(

(MS.[Entry Type]='1' AND

MS.[Document No_] LIKE 'MSales%' )

OR

MS[Entry Type]='2')

<!--more-->

Create your availability group, configure the listener, add databases. Add as many databases as you need

Application connects using listener name, think of that as your new server name. Connection string...

Can you run: DBCC SHOW_STATISTICS([company$Sales Line],[_WA_Sys_00000001_73A22229])

If this is a statistic on an index, then it cannot be dropped as it exists as long as the index exists.  For your database, do...

If the table has foreign key constraints, chances are you will also need to look at other tables too when deleting such a large number of data

If there are no...

Your transaction log is too big. Shrink the log, then do a manual full and xlog backup. Restore these on the secondary in restoring state and then add database to...

How critical is your application?

You will have an outage between steps 2 and 3 and if the table has foreign key constraints you cannot use truncate table

If you are with...