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
What is database replication?
What are the tools available in market as an alternative to sql server reporting services?
What is the difference between grant and with grant while giving permissions to the user?
Explain a join?
How to choose all records from the table?
What is the name of reporting services config file and what’s it’s used for?
What is TDS(Tabular Data Stream) Gateway?
What you can do to delete a table without the delete trigger firing?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
What is the full meaning of dml?
How to display a past time in days, hours and minutes?
What is the usage of sign function?
What are sql dirty pages?
What is resultset concur_updatable?
Explain the microsoft sql server delete command? : SQL Server Architecture
