THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Internals » rowsize   (RSS)
  • Geek City: Detecting Overflowing Columns

    SQL Server 2005 allows rows to include variable length columns which do not actually fit in the maximum row size of 8060 bytes. I previously posted about row-overflow columns, and discussed the maximum number of such columns that you could have in a single table. You can read that post here. Just recently I received another question that ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 9, 2007
  • Geek City: Maximum Number of Row-overflow columns

      I received a question from one of my readers that concerned this paragraph in Inside SQL Server 2005: The Storage Engine. The number of large variable-length columns that a table can have is not unlimited, although it is quite large. There is a limit of 1,024 columns in any table, so that is definitely a limit there. But another limit ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on July 16, 2007
Privacy Statement