Re: Adding Fields to a large table

Hello Marc,

As Bill mentioned, fixed length data will take up the bytes no matter it is
Null or not. Also, in SQL Server 2000, a NULL bitmap is always present,
even if no NULLs are allowed in any column. You may want to refer to the
following link for more details:

Poking about with DBCC PAGE (Part 1 of ?)
https://blogs.msdn.com/sqlserverstorageengine/archive/2006/08/09/692806.aspx

If you have any further questions or comments, please feel free to let's
know. Thank you!

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • RE: Create beautiful sphere icons
    ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ... professional working with you may need further investigation to reach the ... project analysis and dump analysis issues. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: VS2008 DLL not loading
    ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ... professional working with you may need further investigation to reach the ... project analysis and dump analysis issues. ...
    (microsoft.public.vsnet.debugging)
  • RE: Cant create web project
    ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ... professional working with you may need further investigation to reach the ... project analysis and dump analysis issues. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Error Rendering Control
    ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ... professional working with you may need further investigation to reach the ... project analysis and dump analysis issues. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: DataGridView.EndEdit Question
    ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ... professional working with you may need further investigation to reach the ... project analysis and dump analysis issues. ...
    (microsoft.public.dotnet.languages.csharp)
Loading