Adam St. Pierre
July 23, 2017 at 11:20 pm
Comments posted to this topic are about the item The Case of the Space at the End
July 24, 2017 at 6:06 am
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.
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.)
July 24, 2017 at 6:51 am
Ugh.. RTFM. Gets me more often than it should. Thanks for the link!
Mr or Mrs. 500
July 24, 2017 at 7:13 am
"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
July 24, 2017 at 3:48 pm
Thanks for the article! I've never run into the situation, but it is very good to know.
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