Truncate Table

Question

Post reply

Truncate Table

Vinay Kumar

SSCertifiable

Points: 6099
More actions
March 27, 2013 at 8:23 pm

#272617

Comments posted to this topic are about the item Truncate Table
Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

Viewing 15 posts - 1 through 15 (of 32 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Thanks for a nice clear question

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Lokesh Vij SSChampion Points: 10836 More actions · Answer 2

Good one Vinay!

Thanks

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

kapil_kk SSC-Insane Points: 21316 More actions · Answer 3

Good one

+1

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

manik_anu SSCrazy Points: 2397 More actions · Answer 4

good question... Looked something different

Manik
You cannot get to the top by sitting on your bottom.

Koen Verbeeck SSC Guru Points: 259165 More actions · Answer 5

Whoops, guessed the wrong one. Nice question, learned something.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

call.copse SSCoach Points: 18158 More actions · Answer 6

I'm happy to admit I didn't know that one - it does make sense logically but I had to check.

TomThomson SSC Guru Points: 104773 More actions · Answer 7

TomThomson

SSC Guru

Points: 104773

March 28, 2013 at 4:31 am

#1601537

Nice straightforward question.

Tom

Gobikannan SSCrazy Points: 2735 More actions · Answer 8

Good straightforward question.

-----------------
Gobikannan

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 9

Awesome, actually really nice one.

(I had developed imaginary theory on this long back- what if the table is self joined with the key and would truncate work? - and I answered myself "probably yes - as it is a same table" - but never tried it practically, this was really good to see my imagination in the reality)

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Venkat Jonnalagadda Mr or Mrs. 500 Points: 510 More actions · Answer 10

AAhhhh!!!!!! This one hurts.. I didn't trust my instincts and on top was lazy to check...

___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:

Mike Hays SSCommitted Points: 1871 More actions · Answer 11

Mike Hays

SSCommitted

Points: 1871

March 28, 2013 at 7:14 am

#1601605

Interesting, good question.

Dana Medley SSCertifiable Points: 6764 More actions · Answer 12

Great question. Took a guess on this one and got it right. Definitely learned something today. Thanks!

Everything is awesome!

mtassin SSC-Insane Points: 23099 More actions · Answer 13

Koen Verbeeck (3/28/2013)
Whoops, guessed the wrong one. Nice question, learned something.

+1 didn't realize this either... probably because in general the tables I want to truncate have additional foreign keys that depend on them

Still... good to know.

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]

SQLRNNR SSC Guru Points: 281344 More actions · Answer 14

EZ PZ

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Truncate Table

Cookies on SQLServerCentral