Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25569 Views
- I also Faced
- E-Mail Answers
Answer Posted / gk singh
truncate provide faster processing than delete because of
truncate does'n require transaction log uddation
| Is This Answer Correct ? | 22 Yes | 2 No |
Post New Answer View All Answers
What is the difference between writing data to mirrored drives versus raid5 drives
What does indexation mean?
What are the dis_advantages of stored procedures, triggers, indexes?
Tell me what is the significance of null value and why should we avoid permitting null values?
How to select some specific columns from a table in a query in ms sql server?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
Where are full-text indexes stored?
Explain system views?
What is normalization of database?
What are the two modes of authentication in sql server?
What is an etl file?
Determine when an index is appropriate?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
When would you use the stored procedures or functions?
How can you check the version of sql server?
