Truncate is more faster reason truncate direct drop the data page and not

Which one is faster delete/truncate? Why?

Question Posted / pankaj dhatrak

Answer Posted / pankaj dhatrak

Truncate is more faster
reason truncate direct drop the data page and not save the transactions.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Give an example of why you would want to denormalize a database

976

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1063

Explain “@@rowcount” and “@@error” in sql server?

1092

List types of tables in SQL Azure?

126

What is user-defined inline table-valued function?

954

What are the Advantages of using CTE in sql server?

1119

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1099

What is transaction server isolation?

1039

How network traffic be reduced by using the stored procedure?

1118

How to round a numeric value to a specific precision?

1075

How to backup encryption key ?

182

What the different types of Replication and why are they used?

1071

What is read uncmmited?

1060

What is a livelock?

966

what is raid? : Sql server database administration

1041