please find the estimated execution plan.

https://www.brentozar.com/pastetheplan/?id=Hy4Dx3Lga

• This reply was modified 1 year, 1 month ago by  vsamantha35.

I cant get the actual plan but I will try it is executing for ever, especially its getting stuck at 3rd INSERT. But I am attaching the estimated plan.

There are a couple of options:

1. Add a new file to the filegroup sized at 1TB with a large auto growth setting (20GB or more).  Issue a DBCC SHRINKFILE...

It took 14 hours to complete.

I would remove INDEX_REORGANIZE from it - and unless you have tested and proved that INDEX_REBUILD_ONLINE is the best for your indexes, I would also remove it - it...

Thank you Sir. Will watch it.

The intention was to know the reason do we need to bother about fragmentation for tables with 10's or few 100's of pages. I see dev team asking...

The intention was to know the reason do we need to bother about fragmentation for tables with 10's or few 100's of pages. I see dev team asking question to...

Thank you Sir. will go through Paul White's blogs.

:

:

:

:

:

:

Finally, I see a lock escalation at the end of the trace.

Thank you frederico. Yes, it is a busy server.

Does it make any difference with the on-going open transactions to the database? is it better to do during maintenance windows when there are no incoming connections from the application?...

We are trying to delete data from logging table which has grown upto 7 TB. App team now decided to delete the data based on some filters. As they are...

Thank you Sir.

The db that table was in already had space allocated but that had not been used yet.  Therefore, SQL can allocate that space to a table without having to...