Truncate log file in SQL Server
Every now and then questions come up forums asking about how to truncate log file in SQL Server. Truncating a transaction log file means clearing out space in the log file. …
Truncate log file in SQL Server Read MoreTag: Truncate
SQL Server: Myth > Truncate Cannot be Rolled back
Hi Friends, The Truth is: Truncate Table Command can be rolled back. Actually Truncate Table command is minimally logged, SQL Server logs only the page deallocations in TLog. So, in order …
SQL Server: Myth > Truncate Cannot be Rolled back Read MoreDelete VS Truncate in SQL Server
What are the differences between Delete and Truncate in SQL Server? This is one of the most frequently asked questions in SQL server interviews and the answer varies depending upon your …
Delete VS Truncate in SQL Server Read More