I have written an SSIS package to load test data into an empty database. Some of the tables are very large (~700 million rows). Once the SSIS package has completed are there any commands I should run (as an apprentice DBA!) to maximize the performance of the database?
For instance, I executed
EXEC sp_updatestats but it reported that no indexes required updating.
Is there a list of things to do once large amounts of data has been loaded or does SQL Server 2008 just take care of all that for you?