Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Data Typing Quandry Expand / Collapse
Author
Message
Posted Tuesday, November 16, 2010 9:10 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 13, 2014 4:42 PM
Points: 1,618, Visits: 1,549
Comments posted to this topic are about the item Data Typing Quandry



My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master: SQL Server 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #1021898
Posted Tuesday, November 16, 2010 9:12 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 4:43 AM
Points: 1,130, Visits: 1,391
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
Posted Tuesday, November 16, 2010 10:20 PM


Default port

Default portDefault portDefault portDefault portDefault portDefault portDefault portDefault port

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 4:53 AM
Points: 1,433, Visits: 1,845
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://nakulvachhrajani.com
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Post #1021919
Posted Wednesday, November 17, 2010 12:33 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, October 11, 2014 4:03 AM
Points: 1,005, Visits: 988
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
Posted Wednesday, November 17, 2010 1:31 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, May 16, 2011 8:22 AM
Points: 378, Visits: 353
Good question, thanks.
Post #1021954
Posted Wednesday, November 17, 2010 2:02 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 6:53 AM
Points: 2,165, Visits: 1,752
Nice question - I thought they would all be the same size as well.
Post #1021959
Posted Wednesday, November 17, 2010 2:42 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, July 21, 2014 3:43 AM
Points: 1,939, Visits: 1,162
Great Question.Keep continue Posting.

Malleswarareddy
I.T.Analyst
MCITP(70-451)
Post #1021989
Posted Wednesday, November 17, 2010 3:36 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, October 17, 2014 1:15 AM
Points: 1,805, Visits: 496
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
Posted Wednesday, November 17, 2010 5:41 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:20 AM
Points: 969, Visits: 691
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



Post #1022089
Posted Wednesday, November 17, 2010 5:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:32 AM
Points: 2,917, Visits: 2,528
Excellent question - got it wrong but learned something new. It's going to be a great day

Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
Post #1022090
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse