QUESTION
Is "TRUNCATE" and "ROLLBACK" reliable?
If TRUNCATE de-allocates the pages, which can be overwritten by subsequent operations, can the ROLLBACK of a TRUNCATE operation restore the original data?
Eg.
BEGIN TRANSACTION
..
TRUNCATE table1
..
insert to...