Thank you very much Eric for clarifying it so well! Thank u.

Thank u Eric for the insights into this. very helpful. So , for me to buy any space and performance gain , apart from row and page compression, I can...

Had faced somewhat similar issue . A log backup other than the log backup from the Log Shipping config ruins the sequence. As  no other change...

Thanks Eric. Yeah the idea of not consuming the space is clear ,as per other posts too .The overhead of SQL spending resources in allocating n de-allocating the space from...