Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

sql server 2008: Can I have 250-300 fields in a table ?

Posted on 2009-06-27
3
Medium Priority
?
180 Views
Last Modified: 2013-12-17
sql server 2008: Can I have 250-300 fields in a table ?

0
Comment
Question by:nikavak
  • 2
3 Comments
 
LVL 64

Accepted Solution

by:
Fernando Soto earned 2000 total points
ID: 24727994
Hi nikavak;

The simple answer to your question is Yes. Although I do not know why one would want to do that when you think of network throughput the more columns and rows will impact the network traffic.

Columns per nonwide table =  1,024
Columns per wide table      = 30,000

This info can be found at
Maximum Capacity Specifications for SQL Server
http://msdn.microsoft.com/en-us/library/ms143432.aspx

What is the difference between nonwide and wide tables can be found on the following two links.
Special Table Types
http://msdn.microsoft.com/en-us/library/ms186986.aspx
Using Sparse Columns
http://msdn.microsoft.com/en-us/library/cc280604.aspx

Fernando
0
 

Author Closing Comment

by:nikavak
ID: 31597552
Thanks a lot
0
 
LVL 64

Expert Comment

by:Fernando Soto
ID: 24728025
Not a problem, always glad to help.  ;=)
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Screencast - Getting to Know the Pipeline

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question