The Case of the Space at the End

Question

The Case of the Space at the End

Adam St. Pierre

SSC Journeyman

Points: 76
More actions
July 23, 2017 at 11:20 pm

#331978

Comments posted to this topic are about the item The Case of the Space at the End
July 25, 2017 at 3:43 am

This was removed by the editor as SPAM

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

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

sknox SSChampion Points: 12388 More actions · Answer 1

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 More actions · Answer 2

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

Andy Steinke Mr or Mrs. 500 Points: 565 More actions · Answer 3

"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: 1320 More actions · Answer 4

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