This is real sad thing to read such unprofessional statement in such a brilliant forum. This was the first bad thing I read on this forum. Hopefully it should be...

I've been playing with identity columns quite lot in the past two years so found it easy to resolve. But nice question. Cheers 🙂

ScottPletcher (8/27/2013)

---

In Oracle, a TRUNCATE indeed cannot be rolled back. [Oracle uses a fundamentally different way of handling table allocations that would make it essentially impossible for Oracle to...

SQLRNNR (8/27/2013)

---

sknox (8/27/2013)

---

SQLRNNR (8/27/2013)

---

Then you're not thinking in...

L' Eomot/Gail, I am aware with the rest of the differences between DELETE & TRUNCATE. Only had the doubt over the logging difference which was strangely wide spread across the...

GilaMonster (8/27/2013)

---

sqlnaive (8/27/2013)

---

Great... So the correct statement should be:

"DELETE is a logged operation while TRUNCATE is not" as the truncate just deallocates the data pages from the table and that...

I was taking only the...

Great... So the correct statement should be:

"DELETE is a logged operation while TRUNCATE is not" as the truncate just deallocates the data pages from the table and that is the...

Totally agreed Gail. I have been to so many discussions over so many sites about this particular difference between DELETE & TRUNCATE that I'm confused.

"DELETE can be ROLLED BACK but...

Thanks for the second answer Koen. Thanks cool. On first one, let me check once again today and get back by tomorrow. 🙂

Thanks Hugo for confirming it.

See thats the profit of being a part of such a wonderful forum. I learned/clarified things more or less on daily basis even out of such...

Both in 2008. I deployed them to file system. (Not the default path but to new folder with the project name )

Easy question for me. Experience paid for me. 🙂

Hi Koen, I have one simple question and maybe I'm missing something here. I have two VM machines created and in one (kind of dev), I have created one solution...

On the other note, nice to know about the real definition by SQLRNNR and Hugo for Heap table. So the correct definition goes like this:

"A heap table can or cannot...