Interested to Buy Any Domain ? << Click Here >> for more details...
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
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
Explain difference between control flow and data flow?
What is the purpose of update statistics and scope_identity() function?
What command do we use to rename a db, a table and a column?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
Difference between report and query parameter. Why do we need different type of parameter?
Define the one-to-one relationship while designing tables.
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What happens when the SQL Azure database reaches Max Size?
What is the difference between getdate and sysdatetime?
How can you ensure that the database and sql server based application perform well?
What is update_statistics command?
Why do we use non clustered index?
What is Service Broker in sql server 2012?
