Good summary and beginner article. You might want to look at your definition of is_ansi_padding_on. YOu state that when ON CHAR(n) and BINARY(n) are padded out to the length. Those are always padded, setting ansi padding on causes VARCHAR(n) and VARBINARY(n) to be padded.
Jason...AKA CirqueDeSQLeil _______________________________________________ I have given a name to my pain...MCM SQL Server, MVP SQL RNNR Posting Performance Based Questions - Gail Shaw[/url] Learn Extended Events