Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24936 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
How many non clustered indexes there can be on table ?
what is blocking? : Sql server database administration
if no size is defined while creating the database, what size will the database have? : Sql server administration
How do you use a subquery to find records that exist in one table and do not exist in another?
Describe and explain about SQL native client?
What program is used to store the data source file?
What is the use of custom fields in report?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What is dml command?
What is user defined datatypes and when you should go for them?
What happens if null values are involved in string operations?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What is the minimum recommended amount of ram for sql server 2012 enterprise?
what are the types of indexes? : Sql server database administration
What is 3nf normalization form?
