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

---

michael.kaufmann (5/16/2011)

---

I'm even more confused now ... :w00t:

The edited correct answer reads:

[...] Rows CAN span multiple pages.

[...] Ref: Pages and Extents - http://msdn.microsoft.com/en-us/library/ms190969.aspx...

I'm even more confused now ... :w00t:

The...

Nils Gustav Stråbø (5/13/2011)

---

No. LOB data are text/image and the variable length max data types. ROW_OVERFLOW_DATA can contain any variable length column. Ref Table and Index Organization

My following example contains...

Nils Gustav Stråbø (5/13/2011)

---

A row cannot span multiple pages of type IN_ROW_DATA, but it can certainly span multiple ROW_OVERFLOW_DATA and LOB_DATA pages. So when Brandie excluded LOB_DATA, there is still...

I guess this needs to be argued with Microsoft :hehe:

BOL states that "Rows cannot span pages"; if the amount...

tommyh (5/6/2011)

As a response to this and to michael.kaufmann. The question wasnt about backup compression but data compression... its not the same thing. And data compression is an Enterprise feature....

jadsmith (5/6/2011)

---

It would depend on if the database backed up contains Enterprise features or not. If not the backup should restore with no problems. The question doesn't say that there...

pdooley-1104895 (4/18/2011)

---

I wish you would have asked about a SET @dvalue = 10.12

Even though I got the answer correct the 10.10 clouds weather the (10) or the (.10)...

paul.james 64212 (3/28/2011)

---

Christian Buettner-167247 (3/28/2011)

---

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...

Thank you very much for your kind words of appreciation, Duncan.

Thanks again for your question and great explanation.

Regards,

Michael

tilew-948340 (3/20/2011)

---

I am sorry, but I realy, realy don't understand why D is not good, even if I do your formula.

Why is so that D would have a truncate...

bitbucket-25253 (3/14/2011)

---

Here we go again -- the specified as correct answer is an item to be depreciated in a future release of SQL Server and one possible answer, and the...

Taking my motorcycle out for the first ride after the winter. 🙂

-Michael

BTW: Had...

SoftwareArtiste (3/9/2011)

---

mvelic (3/9/2011)

---

Well, I got this wrong but I think I would have worded it differently. If you don't take a tail of the log backup after the TRUNCATE TABLE...

First of all thank you very much for the question. Excellent to recap how SQL Server stores data and index information. 🙂

Following the same link to SQLServerPedia (http://sqlserverpedia.com/wiki/Heaps), the follwing...