Improvements in SQL Server 2008 T-SQL command
sql server 2008 integrates many remarkable new features. one of these features is improvements in t-sql statements that reduce the time spent working on these statements.Restore SQL Server from Transaction Log
transaction log (also known as database log or binary log) is an action history that is executed by the database system to ensure acid properties when the system fails.