Whats the best method to update sqlserver when data is large?
Scenario:

i am trying to insert 47,000 records to a table in SQL Server with 95 fields, but it took me 1.5 hours to complete the proccess. I am using SPT to update the table.

thanks in advance