truncate provide faster processing than delete because of truncate does&#

Can you tell me the difference between DELETE & TRUNCATE
commands?

Question Posted / gk singh

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

Please Help Members By Posting Answers For Below Questions

Explain the difference between cross join and full outer join?

921

What is the recovery model?

928

what's the maximum size of a row? : Sql server database administration

1008

Where are full-text indexes stored?

944

Explain the properties of the relational tables?

936

What are distinctive joins find as a part of sql?

904

Explain what is the difference between union and union all?

948

Why we use the openxml clause?

951

Explain the benefits of user-defined functions?

984

Why de-normalization required?

938

How to convert character strings into numeric values?

1030

Explain what you mean by 3 tier architecture.

1015

How to insert data with null values?

966

What is an index in sql?

955

How will you hide an attribute? : sql server analysis services, ssas

891