Data Typing Quandry

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Robert Davis » Data Typing Quandry

37 posts, Page 1 of 4

1 2 3 4 »»»

Data Typing Quandry

Rate Topic

Display Mode

Topic Options

Author

Message

Robert Davis

Posted Tuesday, November 16, 2010 9:10 PM

SSCommitted

Group: General Forum Members
Last Login: Sunday, May 19, 2013 8:09 AM
Points: 1,558, Visits: 1,396

Comments posted to this topic are about the item Data Typing Quandry

My blog: SQL Soldier
Twitter: @SQLSoldier
Microsoft Certified Master: SQL Server 2008
Sr. Product Consultant and Chief SQL Server Evangelist @ Idera
My book: Pro SQL Server 2008 Mirroring

Post #1021898

Hardy21

Posted Tuesday, November 16, 2010 9:12 PM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 7:11 AM
Points: 877, Visits: 1,159

Very nice question though I got it wrong.
I was thinking because of only 3 bit column, it should take 1 byte only same as tinyint.

Thanks

Post #1021899

Nakul Vachhrajani

Posted Tuesday, November 16, 2010 10:20 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 1:02 AM
Points: 1,277, Visits: 1,609

Really very nice question. Gets the mind thinking about the internal storage and is a very, very important consideration for capacity planning.
I got it right, but I must admit that it was only because of two points:
1. I am currently trying to understand database compression
2. I just read about this in Books On Line (It's hardly been two days!)

Great question, great discussion sure to follow! I am looking forward to following the entire thread.

Have a wonderful rest-of-the-day!

Thanks & Regards,
Nakul Vachhrajani.
http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.

Follow me on
Twitter: @nakulv_sql
Google Plus: +Nakul

Post #1021919

Iulian -207023

Posted Wednesday, November 17, 2010 12:33 AM

SSC Eights!

Group: General Forum Members
Last Login: Saturday, March 16, 2013 9:53 AM
Points: 847, Visits: 768

Great question, thank you.

I answered wrong by assuming there is no place for compressing bit fields more than it already does, in this case to one byte, I should have thought about the header.

Have a great day,
Iulian

Post #1021946

Jinx-640161

Posted Wednesday, November 17, 2010 1:31 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 16, 2011 8:22 AM
Points: 378, Visits: 353

Good question, thanks.

Post #1021954

Richard Warr

Posted Wednesday, November 17, 2010 2:02 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 5:05 AM
Points: 1,608, Visits: 1,097

Nice question - I thought they would all be the same size as well.

Post #1021959

malleswarareddy_m

Posted Wednesday, November 17, 2010 2:42 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 8:05 AM
Points: 1,846, Visits: 980

Great Question.Keep continue Posting.

Malleswarareddy
I.T.Analyst
MCITP(70-451)

Post #1021989

Michael Riemer

Posted Wednesday, November 17, 2010 3:36 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:10 AM
Points: 1,239, Visits: 346

Great question and interesting - Learnt something new today. Thought I understood compression but need to look into it a bit more it seems!

Post #1022021

RichardDouglas

Posted Wednesday, November 17, 2010 5:41 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, May 20, 2013 3:35 AM
Points: 969, Visits: 650

Interesting, I knew there was an overhead to data compression but went for TinyInt over Bit.

Good question, thanks for taking the time to help educate the SQL community.

Hope this helps,
Rich