Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Which one is faster delete/truncate? Why?



Which one is faster delete/truncate? Why?..

Answer / pankaj dhatrak

Truncate is more faster
reason truncate direct drop the data page and not save the transactions.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

what are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  


How to find out the list schema name and table name for the database?

0 Answers  


How to store and query spatial data?

0 Answers  


Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 Answers  


What is clr ddl trigger?

0 Answers  


What are the purpose of Normalisation?

0 Answers   HCL,


How to turn off warning messages during php execution?

0 Answers  


how can you attach more than 20 ldf files in sql server

0 Answers   IBM,


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

0 Answers  


How can a user-defined datatype be created?

0 Answers  


Define right outer join in sql server joins?

0 Answers  


Define outer join in sql server joins?

0 Answers  


Categories