This is from Bob Ward's Blog - http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx This is the summary from his blog above. It is very good information. Bob did very good job of explaining this...

The Default Trace is something completely new that Microsoft has implemented to audit certain events in the system, which you can report on via Management Reports. To verify if the default trace is running, run following query: select * from sys...

In following cases you will need to generate a scripts for all the clustered and non-clustered indexes on the SQL Server 2005 database: 1. During heavy bulk inserts into a table, you might want to drop all the indexes on the table to make the bulk...