Comments posted to this topic are about the item The Case of the Space at the End
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.)
Ugh.. RTFM. Gets me more often than it should. Thanks for the link!
Mr or Mrs. 500
"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!
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 5 (of 5 total)