Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mjaiswal
Starting Member
1 Post |
 Posted - 2010-05-18 : 01:08:05
|
| Hi,Having an average rated SQL Server skillset, I would appreciate if some one can help me out with this problem:There is a DemoTable with N no. of columns. I need to modify the number of columns as per the requirements. There is a large volume of data existing already. If I do not use 90% of the columns, there will be records with mostly NULL values. This will hamper the performance when the table is queried. Creating a new table is an option. Is there an option to archive the existing table's data and then modify. This is so that the archived version can only be used for querying.Please let me know.Thank you,MJ |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-18 : 02:03:55
|
| you can create a copy of table and then do changes. if possibility of storing values in columns are small,consider going for EAV approach. or if using SQL 2008, use SPARSE columns------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Make existing Table as History