Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Will Number of columns in a table can affect performance in SQL server? Expand / Collapse
Author
Message
Posted Thursday, June 17, 2010 3:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 17, 2010 9:45 PM
Points: 1, Visits: 1
Currently I am involved in an ERP application development. In that, few of the main tables having more than 50 columns. Instead of creating multiple tables (Normalize) we add columns in existing tables to satisfy the functionality and reduce coding efforts. So the Data is now centralized into a single table.

Can someone tell me Will this affect query performance?
What would be the advisable number of columns in a Table regarding performance ?

Regards,
tamil
Post #938742
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse