Cliff Jones (8/5/2009)

---

Hugo Kornelis (8/5/2009)

---

You'll see that after the TRUNCATE TABLE, the space used is zero - but after the INSERT INTO, it is right back at its original size,...

stevecable (7/31/2009)

---

The answer claims "Even though TRUNCATE TABLE does remove all the data pages and could theoretically be a great time to change the metadata, it doesn't work this way...

Frankly, I have no idea. I guess I could test but I can't really be bothered....

angelo.cas (7/28/2009)

---

Well I would have added and removed the clustered index. It's by far the simplest process that would have less room for fault or down time on the...

Stuart M. Garner (7/28/2009)

---

Interesting that in the explanation for the "correct" answer it states:

Creating a clustered index does involve a rebuild of all the data pages, so this will also...

andrew.me.ph (7/28/2009)

---

As to me, this is a silly answer: since both building clustered index and copying data multiple times solve "the problem" - presenting multiple copy as a correct...

mtassin (7/28/2009)

---

The Garbage collection process is also a correct answer.

So sp_spaceused for a large table (1 million rows seems large...

Chad Crawford (7/28/2009)

---

Hugo (et al.), I was running some scripts (in 2K5) based on this question to learn a little more and I noticed that the delete doesn't seem...

nico van niekerk (7/28/2009)

---

I clicked the correct answer but it still said that I was wrong and cited an option I didn't click.

Then, it is not "than", it is...

Hi all,

First: Apologies for the late replies. Unfortunately, Steve ran this question just during my holiday, so I was busy soaking in sun, blissfully unaware of your reactions. I am...

ramu.valleti (7/7/2009)

---

Can any one please help me...

when i execute the following query,

BEGIN TRANSACTION T1

INSERT INTO table_1 VALUES ('ABA','xxx',130)

COMMIT TRANSACTION T1

BEGIN TRANSACTION T2

INSERT INTO table_1...

Seconded.

(I lost my point - I was so focused on the details of the nested transactions that I failed to see that the code used a table variable instead of...

Tao Klerks (7/7/2009)

---

Hugo Kornelis (7/6/2009)

---

Edit: Afterthought 1: Tao's examples are not great at all. The 1 predicate can match many more rows than the IN(2,3) predicate, so one should expect...

Never. There's always room for improvement. 😉

I...

Paul White (7/6/2009)

---

Hugo Kornelis (7/6/2009)

---

I see that you now have made a small change to the explanation, but I still do not like it.

"It is sometimes a better practice to...