<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by bitbucket
»
Table Design
25 posts, Page 1 of 3
1
2
3
»
»»
Table Design
Rate Topic
Display Mode
Topic Options
Author
Message
bitbucket-25253
bitbucket-25253
Posted Saturday, March 05, 2011 6:44 PM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 8:55 AM
Points: 5,099,
Visits: 20,190
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
Koen Verbeeck
Koen Verbeeck
Posted Sunday, March 06, 2011 11:45 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 6:54 AM
Points: 9,364,
Visits: 6,462
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
mohammed moinudheen
mohammed moinudheen
Posted Sunday, March 06, 2011 11:29 PM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 3:34 PM
Points: 2,170,
Visits: 3,582
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
Carlo Romagnano
Carlo Romagnano
Posted Monday, March 07, 2011 1:17 AM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 2:04 AM
Points: 1,968,
Visits: 1,819
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
Jamie Longstreet-481950
Jamie Longstreet-481950
Posted Monday, March 07, 2011 2:28 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 6:57 PM
Points: 2,440,
Visits: 712
good question
Jamie
Post #1073998
paul s-306273
paul s-306273
Posted Monday, March 07, 2011 3:20 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 4:24 AM
Points: 1,158,
Visits: 642
Excellent question today - thanks Ron.
Post #1074017
sujitkmishra
sujitkmishra
Posted Monday, March 07, 2011 5:05 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, December 27, 2012 4:39 AM
Points: 110,
Visits: 246
Excellent question. Thanks
Post #1074056
Nakul Vachhrajani
Nakul Vachhrajani
Posted Monday, March 07, 2011 5:26 AM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 9:52 AM
Points: 1,277,
Visits: 1,608
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://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.
Follow me on
Twitter:
@nakulv_sql
Google Plus:
+Nakul
Post #1074063
bitbucket-25253
bitbucket-25253
Posted Monday, March 07, 2011 6:19 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 8:55 AM
Points: 5,099,
Visits: 20,190
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
Chris Houghton
Chris Houghton
Posted Monday, March 07, 2011 6:39 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: 2 days ago @ 9:12 AM
Points: 557,
Visits: 1,356
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 »
25 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
