How to migrate wide Excel worksheet into SQL Server table

23 January,2020 by Jack Vamvas

Question: What is the limit on SQL Server Maximum Columns per table?  I have a very wide Excel worksheet and want to migrate the data to a SQL Server table - where we can then manage the data?

Answer: The standard SQL Server table maximum columns limit is 1024. Tables that include sparse column sets include up to 30,000 column

A Sparse column set combines the table's sparse columns and translates into a structured  representation. The column set is not stored physically in a table. 

 

Read more on SQL Server tables

 Table sizes and percentages (SQL Server DBA)

SQL Server - How to find the largest sql index and table size 

SQL Server resizing a column on a large table 

 

 


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on How to migrate wide Excel worksheet into SQL Server table


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer