SQL Server performance for tables having large number of columns
If a table has 600 columns it is a very good idea to review the database design. You could move several columns into separate tables, especially the ones with 98% and more NULL values.

Also you will run into trouble if your row does not fit into a single page any more. (see here.)