Post reply

Table Design

  • March 5, 2011 at 6:44 pm

    #235601

    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[/url]
    Before posting a performance problem please read[/url]

  • March 6, 2011 at 11:45 am

    #1295133

    Nice question, thanks.

    I had to read it a few times...

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

  • March 6, 2011 at 11:29 pm

    #1295183

    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.

    M&M

  • March 7, 2011 at 1:17 am

    #1295195

    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'.

  • March 7, 2011 at 2:28 am

    #1295209

    good question

    Jamie

  • March 7, 2011 at 3:20 am

    #1295226

    Excellent question today - thanks Ron.

  • March 7, 2011 at 5:05 am

    #1295252

    Excellent question. Thanks

  • March 7, 2011 at 5:26 am

    #1295257

    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

    Follow me on
    Twitter: @sqltwins

  • March 7, 2011 at 6:19 am

    #1295284

    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[/url]
    Before posting a performance problem please read[/url]

  • March 7, 2011 at 6:39 am

    #1295300

    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!

  • March 7, 2011 at 6:49 am

    #1295305

    Jamie Longstreet-481950 (3/7/2011)

    This is a good question because it shows just how naive the SQL system can be when it comes to query optimization.

    Jamie - It was my understanding that this question was about how data is stored in the data pages. What did you see that made you think about query optimization?

  • March 7, 2011 at 6:51 am

    #1295307

    Great Monday Morning QOTD. Thank you.

  • March 7, 2011 at 7:32 am

    #1295331

    Interesting question - thanks.

    The link in the explanation seems to be for page containing all Kimberly's SQL 2005 articles- for the exact post relating to this question I think the link is: http://sqlskills.com/BLOGS/KIMBERLY/post/Column-order-doesnt-matter-generally-but-IT-DEPENDS!.aspx

  • March 7, 2011 at 7:42 am

    #1295339

    Great question!! Learned something new today.

    Thanks!!

  • March 7, 2011 at 7:52 am

    #1295344

    Totally irrelevant to the question of course, but I needed to tell someone:

    I've now finally answered every QOD in existance! (until tomorrow's comes out, anyway)

    It's been a tough journey, but feels good to have finally got up to date. :hehe:

Viewing 15 posts - 1 through 15 (of 24 total)

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