Answer:
The record-size limit for tables that use SPARSE columns is 8018 bytes. When the converted data plus existing record data exceeds 8,018 bytes, The Error will be thrown "MSSQLSERVER ERROR 576".
When columns are converted between SPARSE and NONSPARSE types, Database Engine keeps a copy of the current record data. This temporarily doubles the storage that is required for the record, So the Error triggered.
Asked In: Many Interviews |
Alert Moderator