November 25, 2013 at 6:20 am
I have a requirement where i need to create a table with about 600 columns. Out of 600 columns about 200 columns will be XML columns. Other column will be of other datatypes such as int,varchar,nvarchar etc.
Also about 50% XML column will have about 40 to 60 rows and other will have less number of rows. The entire table will have about 2000 to 3000 rows. Theoretically SQL allows maximum of 1024 columns. But what will be the performance in my scenario? Does this design will bad effect on performance?
Also does SQL server has limitation for row size?
November 25, 2013 at 7:04 am
In theory SQL Server has a maximum of 8Kb per row. (which can be overflowed by using variable length columns)
However, blob and XML columns do not take part in this maximum, so I would assume you're safe.
Row-Overflow Data Exceeding 8 KB
No idea on the performance though, this depends on a lot of factors.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply