March 27, 2013 at 8:23 pm
Comments posted to this topic are about the item Truncate Table
Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
March 27, 2013 at 8:24 pm
March 27, 2013 at 10:43 pm
Good one Vinay!
Thanks
~ Lokesh Vij
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
March 27, 2013 at 11:24 pm
Good one
+1
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 28, 2013 at 1:07 am
good question... Looked something different
Manik
You cannot get to the top by sitting on your bottom.
March 28, 2013 at 3:41 am
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
March 28, 2013 at 3:48 am
I'm happy to admit I didn't know that one - it does make sense logically but I had to check.
March 28, 2013 at 4:31 am
Nice straightforward question.
Tom
March 28, 2013 at 4:41 am
Good straightforward question.
-----------------
Gobikannan
March 28, 2013 at 5:34 am
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.
March 28, 2013 at 7:07 am
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:
March 28, 2013 at 7:14 am
Interesting, good question.
March 28, 2013 at 7:38 am
Great question. Took a guess on this one and got it right. Definitely learned something today. Thanks!
March 28, 2013 at 7:58 am
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.
March 28, 2013 at 8:06 am
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
Viewing 15 posts - 1 through 15 (of 32 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy