Tech Off Post

Single Post Permalink

View Thread: Question - What would you do?
  • User profile image
    Maddus Mattus

    W3bbo said:
    Maddus Mattus said:

    The effect is negligible. an int is 32 bits, a datetime is 64 bits. On an x64 DBMS the int would be padded out to 64-bits to fit into a word size, so it's possible that the overhead is with using an int rather than a 64-bit type Wink

    I don't mean overhead in storage mate Wink


    I mean overhead for dealing with a number, that is stored in a too complex data type for it's own good Smiley


    Year -> int

    Date -> DateTime


    Then you dont need to do nasty where statements like where datepart(myDate, yy) = 2010 etc etc