InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 19:24:52 GMT20http://www.sqlservercentral.com/Forums/Topic414168-34-1.aspxgr8 question with the answer in the title itself :-PWed, 28 Nov 2012 00:29:12 GMTkapil_kkhttp://www.sqlservercentral.com/Forums/Topic414168-34-1.aspxHmm - dropping the table is the fastest way as it logs the least and doesn't take any locks, compared to truncate table. I think that was a bad question as the answer they wanted was truncate - drop shouldn't have been an option.Wed, 02 Apr 2008 05:26:36 GMTPaul Randalhttp://www.sqlservercentral.com/Forums/Topic414168-34-1.aspx[quote][b]Nicholas Cain (10/30/2007)[/b][hr]I do not believe that the answer is correct.The question was the fastest way to delete every row in a table.Delete and truncate are not the same thing.Should the question have read "to remove all rows from a table" then I would agree with the truncate statement.This does not take into account things like identity values which would continue from the most recent number rather than completely reseed post truncate.[/quote]The question doesn't take that into account, therefore nor should your answer. DELETE and TRUNCATE do indeed work differently, but both have the effect of deleting all rows. I can't see the difference between "delete every row in a table" and "remove all rows from a table".JohnEdit: actually, having looked at the choices again, neither of the DELETE options has correct syntax anyway.Tue, 30 Oct 2007 09:49:22 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic414168-34-1.aspxI do not believe that the answer is correct.The question was the fastest way to delete every row in a table.Delete and truncate are not the same thing.Should the question have read "to remove all rows from a table" then I would agree with the truncate statement.This does not take into account things like identity values which would continue from the most recent number rather than completely reseed post truncate.Tue, 30 Oct 2007 09:41:29 GMTNicholas Cainhttp://www.sqlservercentral.com/Forums/Topic414168-34-1.aspxSurely drop table is quicker?Mon, 29 Oct 2007 12:31:12 GMTRichBhttp://www.sqlservercentral.com/Forums/Topic414168-34-1.aspxI thought it had to be some sort of trick question. (Halloween and all). :)Wed, 24 Oct 2007 06:54:28 GMTBob Faziohttp://www.sqlservercentral.com/Forums/Topic414168-34-1.aspxIt would certainly help my average!<P>Seriously though, apologies for the mistakes made in today's and yesteday's QoDs.</P><P>Tony.Wed, 24 Oct 2007 04:16:32 GMTTony Davishttp://www.sqlservercentral.com/Forums/Topic414168-34-1.aspxCan we have more questions where the answer is in the title of the question!JohnWed, 24 Oct 2007 01:46:18 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic414168-34-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/T-SQL/61356/">Truncate Table</A>[/B]Tue, 23 Oct 2007 21:49:52 GMTSite Owners