Hi,
working with oracle databases i learned that a truncate table statement cannot be rolled back because DDL Statements are not logged.
with an SQL-Server obviously i can truncate a table and get the data back
begin transaction
truncate table myTable
rollback
I even can create a table and roll the creation back!
What do you think about it? Wouldn't this cause that SQL-Server is slower in cases of massdata processing than oracle?
Maybe there is an option to deactivate this behaviour?
Tobias