Does SQL server allow to 1. Truncate log AND 2. Shrink Log While the Log-Shipping is ON ?

OR

Do we need to stop the log-shipping and then "backup log with...

well,

Fill-factor is 90% for selected objects otherwise default is 0.

NOW, I have disabled REBUILD ALL task, however reorganize and update statistics are still there. Database was remain in FULL...

Yes !!!

I have studied some other articles and white-papers.

Its definitely index rebuild which i am doing daily. The steps are

1. Database backup

2. database Integrity

3. Reorganize ALL index

4. Rebuild ALL index

Because...

Well !!!

In that case, there will be three different insert statements (3 loops for same purpose) to prepare three separate temporary tables

and

then join all four tables to UPDATE the final...