As mentioned above, the answer for

is "it depends".

Either that Text part of the...

I got caught by the wording of Extents can be owned by only one object as well.

Maybe a language issue, but I interpreted it as the complementary answer to Extents...

Steve Jones - SSC Editor (5/9/2011)

---

Christian Buettner-167247 (5/9/2011)

---

The answer does not sound right to me.

For heaps, there are no page splits, therefore the only counter that gives me the answer...

The answer does not sound right to me.

For heaps, there are no page splits, therefore the only counter that gives me the answer for both, indexes & heaps, is the...

paul.james 64212 (3/28/2011)

---

OK, can somebody suggest why this returns "Msg 102, Level 15, State 1, Line 4 Incorrect syntax near '='." on my 9.0.4207 SQL server?

declare @i tinyint

SELECT...

Tom.Thomson (3/27/2011)

---

One comment though: depending on settings of ARITHABORT and ANSI WARNINGS, it is quite possible that none of the answer options will result, because the batch is terminated before...

Very good question, indeed. +++

CirquedeSQLeil (3/2/2011)

---

Are we sure about that answer?

http://msdn.microsoft.com/en-us/library/bb934013.aspx States:

" Disabling Resource Governor has the following results:

All existing workload group and resource pool settings are reset to their default values.

"

The default values...

Got the question right, but why is a page full with 4 rows á 1000 bytes?

What? Only 4 points for this tough question? You must be kiddin' me!:-P

Good one.

This explanation here is a little more detailed:

luciano furlan (2/7/2011)

---

Christian Buettner-167247 (2/7/2011)

---

luciano furlan (2/7/2011)

---

No, we don't. Why would I write a where...

luciano furlan (2/7/2011)

---

No, we don't. Why would I write a where clause when I want...

Hi Mohammed,

thank you for responding, but I think you may have misunderstood my question.

But I woke up now anyways. The explanation is simple: Ownership chains.

http://msdn.microsoft.com/en-us/library/ms188676.aspx

Oh, is it groundhog day already?