When placing statistics on a wide column, the server uses
on the first 255 bytes of data. Even if you place an index on a
column created as char(500),
only the first 255 bytes will contribute towards the column histograms
in sysstatistics. For unichar columns,
the first 127 chars will be used to gather column
distributions.
