tag:blogger.com,1999:blog-5849265.post114925846848333697..comments2023-10-29T20:45:15.971+05:30Comments on Vadivel's blog: Delete Vs Truncate StatementVadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-5849265.post-30680194244738125552011-11-18T13:11:11.081+05:302011-11-18T13:11:11.081+05:30Hi Vadivel,
i have heard that delete can be rolled...Hi Vadivel,<br />i have heard that delete can be rolled back.<br />If i want to roll back delete statement,How can i do that without keeping in transaction block?<br /><br />that is without using--<br /><br />begin transaction<br />delete from table1<br />rollback transactionsourabh deeprajnoreply@blogger.comtag:blogger.com,1999:blog-5849265.post-43690277035546270252011-08-25T09:38:03.645+05:302011-08-25T09:38:03.645+05:30My requirement is: create a temp table, insert dat...My requirement is: create a temp table, insert data, take a dump, move it to another DB, then truncate the table and then Insert the data and then the above cycle continues periodically.<br />Finding performance issue due to long duration of truncate.<br /><br />Can I use drop table instead of truncate ?<br />any other alternate approach to meet the above requirementChidamparamhttps://www.blogger.com/profile/08047561930574554568noreply@blogger.comtag:blogger.com,1999:blog-5849265.post-77030959596136071662009-07-29T07:45:35.640+05:302009-07-29T07:45:35.640+05:30Hello Anonymous :) Truncate information can also b...Hello Anonymous :) Truncate information can also be rolledback if it happens within a transaction.<br /><br />Check out my other blog post on this topic here - http://vadivel.blogspot.com/2006/12/rolling-back-truncate-operation.htmlVadivelhttps://www.blogger.com/profile/13387133927257826888noreply@blogger.comtag:blogger.com,1999:blog-5849265.post-48049538092888422202009-07-28T15:26:54.206+05:302009-07-28T15:26:54.206+05:30Nice list, however it is misleading in that TRUNCA...Nice list, however it is misleading in that TRUNCATE TABLE can be rolled back within a transaction. TRUNCATE TABLE however cannot be rolled back after a transaction is committed by using the transaction log.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5849265.post-44350050389639551632007-09-19T16:47:00.000+05:302007-09-19T16:47:00.000+05:30very informative!Thanks!very informative!Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5849265.post-69638989292388984562007-09-19T16:46:00.000+05:302007-09-19T16:46:00.000+05:30very gud one!quite informative!very gud one!quite informative!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5849265.post-34538381995224827362007-08-21T21:02:00.000+05:302007-08-21T21:02:00.000+05:30nice.tynice.tyUnknownhttps://www.blogger.com/profile/17784455282722928560noreply@blogger.comtag:blogger.com,1999:blog-5849265.post-3414188053981977352007-05-23T04:16:00.000+05:302007-05-23T04:16:00.000+05:30Thanks, a good one.Thanks, a good one.dangiankithttps://www.blogger.com/profile/08086801433396490333noreply@blogger.comtag:blogger.com,1999:blog-5849265.post-1155739355695978732006-08-16T20:12:00.000+05:302006-08-16T20:12:00.000+05:30This is a nice technical article. Thanks!!VigneshThis is a nice technical article. <BR/><BR/>Thanks!!<BR/>VigneshAnonymousnoreply@blogger.com