Can I find out why Sparse columns with non-zero values occupy 4 bytes of extra space. I find out why it takes 4 bytes of extra space . Please help me?
From MSDN (my bold)
The SQL Server Database Engine uses the SPARSE keyword in the definition column to optimize the storage of the value in this column. Therefore, when the column value is NULL for any row in the table, the values do not require storage.
NON-null " " = , :
, , , SPARSE.
.. MSDN +4
, , ?
SPARSE
Source: https://habr.com/ru/post/1759065/More articles:https://translate.googleusercontent.com/translate_c?depth=1&pto=aue&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=https://fooobar.com/questions/1759060/cross-platform-desktop-application&usg=ALkJrhhQB0oEhfOkcg3Rn-6oE28sLq4nfQeclipse and the ease of the eclipse interface, for casual java programmers - eclipseASP.Net Event Checker Error in Android Android Browser - androidDataGrid Button - Invalid Answer or Callback - asp.netDelphi DLL compatible with other programming languages - delphiHow to format SSRS Tablix - themesIEnumerable vs List - c #https://translate.googleusercontent.com/translate_c?depth=1&pto=aue&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=https://fooobar.com/questions/1759068/treeview-selected-node-style-doesnt-appears-to-selected-node&usg=ALkJrhiW7fFvkXBdu_orY3d9BDYZfr-RgwCan I join a list object in a .NET collection with an enity object in EF - entity-framework-4make sure the files are converted from CRLF to LF in the update window - is there any performance? - gitAll Articles