Pages I

Question

Pages I

SQLRNNR

SSC Guru

Points: 281334
More actions
May 9, 2015 at 6:37 pm

#317310

Comments posted to this topic are about the item Pages I
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
May 11, 2015 at 9:57 am

This was removed by the editor as SPAM

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Junior Galvão - MVP SSCertifiable Points: 6930 More actions · Answer 1

I found answer for this post on blog: http://sqlblogcasts.com/blogs/danny/archive/2008/02/24/row-compression-internal-structure.aspx

webrunner SSC-Dedicated Points: 31862 More actions · Answer 2

Thanks, good question.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Ken SSCoach Points: 17191 More actions · Answer 3

Ken

SSCoach

Points: 17191

May 11, 2015 at 9:59 am

#1797005

Interesting question. Thanks!

Revenant SSC-Forever Points: 42467 More actions · Answer 4

Hmm... As of now, only 28 percent correct. I am one of those who got it wrong, but I did indeed learn something.

Thanks, Jason!

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 5

Interesting question but an easy one only because I am studying "Microsoft SQL Server 2012 Internals" from Kalen Delaney and I have finished the 6th chapter ( Special Storage a month ago ).

I have eliminated FixedVar which appeared before SQL Server 2000 ( moreover compression must be enabled ).

I remember that I have read several pages about the CD Region ( with CD = Column Descriptor )

Compress dialog was eliminated because I have not seen it in the book.

Dictionary is a phase of the compression : surely not a good answer.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 6

Nice one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ed Wagner SSC Guru Points: 287026 More actions · Answer 7

Nice question, Jason, thank you. Like Patrick, I have the 2012 Internals book sitting on my coffee table, but I haven't gotten through it yet. It seems like so many evenings are filling up that I'm just not getting to it. It won't sit stagnant for too long.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Revenant (5/11/2015)
Hmm... As of now, only 28 percent correct. I am one of those who got it wrong, but I did indeed learn something.
Thanks, Jason!

You're welcome

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Ed Wagner (5/12/2015)
Nice question, Jason, thank you. Like Patrick, I have the 2012 Internals book sitting on my coffee table, but I haven't gotten through it yet. It seems like so many evenings are filling up that I'm just not getting to it. It won't sit stagnant for too long.

Speed read like Dr. Reid.:-D

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

ijaz SSCommitted Points: 1912 More actions · Answer 10

Thanks, my asnwer was wrong but learn something today.

cheers

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 11

Tough Question but scored well.

Unable to find the content in the Doc... 🙁

Thanks.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 12

akljfhnlaflkj

SSC Guru

Points: 76202

May 13, 2015 at 7:31 am

#1797531

Thanks for the question. Learned something today.