Welcome to TechNet Blogs Sign in | Join | Help

April 2007 - Posts

SQL Server 2005 Service Pack 2 (SP2) post fixes explained - 9.0.3054 OR 9.0.3059

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
Posted by vishah | 0 Comments
Filed under:

Default Trace in SQL Server 2005

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.configurations
Posted by vishah | 0 Comments
Filed under:

Generating Scripts only for Clustered and Non-Clustered indexes in SQL Server 2005

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 load
 
Page view tracker