Difference Between Shrinking and Truncating the Transaction Log

Introduction The transaction log file stores information about all transactions that are performed on SQL database and their states. In cas...

Read More

SQL Server Truncate and Shrink Transaction Log File

First, we should know what is transaction log file in SQL Server and what is the difference between truncating and shrinking of log file? L...

Read More

Truncate, Delete and Drop Statements in SQL Server

When we want to make some changes in SQL Server database, then we need some statements that can help to do this. SQL Server usages some com...

Read More