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 |
Post New Answer View All Answers
how to create a scrollable cursor with the scroll option? : Sql server database administration
How do you delete a data source?
What is code near application topology?
What is the sql server agent?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What is function of ROLLUP ?
What the different components in replication and what is their use?
what is a self join? Explain it with an example? : Sql server database administration
What happens if you delete a table that is used by a view?
Explain nested join?
How to delete existing triggers using "drop trigger"?
What is sql or structured query language?
What happens if the update subquery returns multiple rows in ms sql server?
What are the different types of collation sensitivity?
Explain the truncate command? : SQL Server Architecture
