• cengland0 (10/16/2009)


    This one got me again. Another trick question.

    The question asked, "Which of these data types will be more efficient?"

    Had it asked, "Which of these data types take less hard drive space?" I might have chosen the correct answer. I selected Varchar because it is more efficient when programming because char pads with extra spaces at the end and you need to rtrim the column before you produce your final output.

    But in terms of I/O we could assume fixed length data types are better than varying ones.

    Kindest Regards,

    Damian Widera
    SQL Server MVP,
    MCT, MCSE Data Platform, MCSD.NET