The Case of the Space at the End

  • Adam St. Pierre

    SSC Journeyman

    Points: 76

    Comments posted to this topic are about the item The Case of the Space at the End

  • sknox

    SSChampion

    Points: 12227

    I'm uncertain if having the ANSI_PADDING OFF will net you any savings on space for char columns, though. I'll leave that to someone who's better at generating large sample sets to investigate.

    No need to generate large samples of data. Just read the manual:

    char [ ( n ) ]
    Fixed-length, non-Unicode string data. n defines the string length and must be a value from 1 through 8,000. The storage size is n bytes.


    [https://docs.microsoft.com/en-us/sql/t-sql/data-types/char-and-varchar-transact-sql%5D

    Char is stored as a fixed-width column in the row data, so it takes up n bytes regardless of padding settings. (The exception to this is if you have some form of compression turned on.)

  • Adam St. Pierre

    SSC Journeyman

    Points: 76

    Ugh.. RTFM. Gets me more often than it should. Thanks for the link!

  • Andy Steinke

    Mr or Mrs. 500

    Points: 565

    "Adam wrote this article to try ANSI if he can PAD his resume…. On."

    I find a Monday morning dad joke with my SQL article to be quite refreshing!  Thanks - this is a well written summary and something I will pass on!

  • John N Hick

    Ten Centuries

    Points: 1279

    Thanks for the article!  I've never run into the situation, but it is very good to know.

  • This was removed by the editor as SPAM

Viewing 6 posts - 1 through 6 (of 6 total)

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