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 123»»»

Table Design Expand / Collapse
Author
Message
Posted Saturday, March 5, 2011 6:44 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 10:58 AM
Points: 5,333, Visits: 25,272
Comments posted to this topic are about the item Table Design

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1073790
Posted Sunday, March 6, 2011 11:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:42 PM
Points: 13,239, Visits: 11,018
Nice question, thanks.
I had to read it a few times...




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1073879
Posted Sunday, March 6, 2011 11:29 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 16, 2014 2:12 PM
Points: 2,278, Visits: 3,798
This is a great question. Even though I knew SQL Server will re-arrange fixed width columns first and the variable columns last, I was unable to get this right.

Mohammed Moinudheen
Post #1073957
Posted Monday, March 7, 2011 1:17 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:21 AM
Points: 2,556, Visits: 2,417
Thank you for qotd. I really learnt something new and useful.
I should read it 10 times carefully, but at last, when I understand that the goal of qotd was to save space on disk I answered quickly 'c40'.
Post #1073978
Posted Monday, March 7, 2011 2:28 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 2:10 PM
Points: 2,669, Visits: 781
good question

Jamie
Post #1073998
Posted Monday, March 7, 2011 3:20 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 8:36 AM
Points: 1,415, Visits: 802
Excellent question today - thanks Ron.
Post #1074017
Posted Monday, March 7, 2011 5:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 3:49 AM
Points: 110, Visits: 254
Excellent question. Thanks
Post #1074056
Posted Monday, March 7, 2011 5:26 AM


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
Thank-you for this great question! Because I started off with main-frame COBOL, I went with common sense (even before the SQL mind took over) and came to the conclusion that the last column, if kept NULL will provide with the maximum savings.

Once again, thank-you, and have a great day!


Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Post #1074063
Posted Monday, March 7, 2011 6:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 10:58 AM
Points: 5,333, Visits: 25,272
Jamie Longstreet-481950 Posted Today @ 4:28 AM
Other than speaking of your own expertise, what is there to convince a developer to follow these obscure rules...


Least anyone feels that it is my own expertise, let me forcefully point out that I found this gem of information by reading a blog posting by Kimberly L. Tripp (link included in the justification for the correct answer).
I hope that this question introduces many to use all the resources available to them, SqlServerCentral, Books On Line, among the obvious and the not so obvious, blog postings of many highly qualified individuals to delve deeper into the inner workings of SQL Server.


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1074098
Posted Monday, March 7, 2011 6:39 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 8:31 AM
Points: 558, Visits: 1,486
Guessed the correct answer for the right reasons. Had to read it a few times to understand what was being asked. I learned something new here. Nice question!
Post #1074115
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse