Apr10

SharePoint column limit and Row-wrapping in SQL

Author // Rogério Cruzeiro Categories // How To, Brain Dump

"SharePoint Server 2010 data is stored in SQL Server tables. To allow for the maximum number of possible columns in a SharePoint list, SharePoint Server will create several rows in the database when data will not fit on a single row. This is called row wrapping.

Each time that a row is wrapped in SQL Server, an additional query load is put on the server when that item is queried because a SQL join must be included in the query. To prevent too much load, by default a maximum of six SQL Server rows are allowed for a SharePoint item. This limit leads to a particular limitation on the number of columns of each type that can be included in a SharePoint list. The following table describes the limits for each column type.

The row wrapping parameter can be increased beyond six, but this may result in too much load on the server. Performance testing is recommended before exceeding this limit..."

http://technet.microsoft.com/en-us/library/cc262787(v=office.14).aspx#Column

 

$web = http://webapplication
$webapp = Get-spwebapplication $web
$webapp.MaxListItemRowStorage = 8 #the default value is 6
$WebApp.update()

About the Author

Rogério Cruzeiro

Being a qualified .NET and SharePoint Consultant, I have over 5 years of experience in Software Development, with special focus on collaboration and content management platforms, solution integration and business intelligence.

I'm particularly pleased to work with Microsoft technologies, especially with the SharePoint platform, ASP.NET, C# and PowerShell, and I'm always searching for new programming methods and for new ways of doing things more efficiently.

My strengths include:

  • SharePoint Development
  • .Net & Web Development
  • PowerShell Scripting
  • SharePoint Migrations
  • SharePoint 2010 Administration
  • SharePoint 2010 Configuration