SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Table with many fields
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ConfusedAgain
Yak Posting Veteran

United Kingdom
82 Posts

Posted - 03/19/2014 :  13:18:00  Show Profile  Reply with Quote
I have a table that has in the region of 150 columns. This is because data comes from various sources and there is not a lot that can be done about this. What I am trying to work out is the best way to deal with this on a performance basis.

The data held in this table is seen via a windows .net application in a datagridview that collects the data from a SQL View of the table.

150 fields in a table is quite a lot to work with would I be better splitting this table so I had the strings in one table the numeric in another and the dates in another all linking back to a main table with a UID.

What is the most efficient method for performance and for maintenance of this data?
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000