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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

‘Order by’ is not allowed in a view how can you sort information from a view?

1122


What is data source document?

1089


How to convert character strings into numeric values?

1149


How to drop an existing schema in ms sql server?

1145


what are the different types of SSRS reports?

160


What are the results of running this script?

975


What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

1056


on line cluster can we make if yes tell me the procedure

2067


What is proper subset of candidate key?

1044


What is the default fill factor value?

1128


How to find index size for each index on table?

1053


What are indexes in ms sql server?

1117


What are different types of database indexes?

1168


Should you normalize audio?

1005


how many layers of tcp/ip protocol combined of? : Sql server database administration

1049