Can you tell me the difference between DELETE & TRUNCATE
commands?
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 do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
What is database architecture? : SQL Server Architecture
Explain how many normalization forms?
What are relationships and mention different types of relationships in the dbms
What is the osql utility?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What is merge replication?
Find nth lowest salary or get nth lowest salary?
What is the use of @@spid?
How would you go about developing a ssrs report?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
Define primary key?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
if no size is defined while creating the database, what size will the database have? : Sql server administration