When will SQL Server throw an Error: "MSSQLSERVER ERROR 576" ?

 Posted by PandianS on 7/15/2010 | Category: Sql Server Interview questions | Views: 7060
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 

Comments or Responses

Login to post response