Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25101 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
Sql server reporting services vs. Crystal reports.
Can we deploy SSRS reports on our personal website?
Explain primary key?
How will you optimize a stored procedure optimization?
What is a trace frag? Where do we use it?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
Write the syntax for stuff function in an sql server?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What are the steps you must follow to hide sql server instances?
How to find tables without indexes?
Tell me extended events in sql server 2008?
what is a transaction? : Sql server database administration
Explain what is it unwise to create wide clustered index keys?
What is an expression in ms sql server?
Explain features of analysis services?
