As general thumb rule most experts agree having the table or index greater than 10000 pages de-fragmentation improves performance lesser , table scan is a effective as non clustered index...

Check if the DNS service is enabled for name resolution to happen.

Cheers

Would need some more detail information before anyone can assist you on this....anyways let me roll the ideas out for you in case it helps you think in right direction...

Alter Database is allowed to failover the server to mirror, the object altering(DDL) may require re-configuration for mirror to work not a great idea...unless you want to break it.

Cheers

SAT

Is it development environment you are working on ? If yes then it wont make much of difference, unless disk space is constraint.

Say you this table is master table...

Which version of windows is installed ?

What is output of the script below when you run on SSMS ?

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Second when you installed what name...

Try this link to get started

http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm

Cheers

Yes disabling the SSRS services at OS level is fair enough.

Do not disable IIS since SSMS tool part of SQL server 2005 depends on IIS to run it.

Try this link below

http://www.sqlservercentral.com/articles/T-SQL/63681/

Most times it is ill-adviced to installing reporting services on same production box where OLTP database is but if you budget is well short of expectations and you need to...

If your application in OLTP then it will perform DML opertions which needs to work , hope you want this work

If you do want user's not to use SSMS...

Most operation in SQL 2005 were placing non-clustered index on separate file group, on SQL 2008 this rule applies.

Clustered index always resides with base table and cannot be placed on...

step 1 Use the dbcc sqlperf command before viewing the VLF's , when you run this command on master database it will list growth percentage of logs files for all...

From my experience mostly rely on perfmon tool to observe the counters instead of process monitor 🙂

This would not answer your question but does keep you away from good looking...

Hope this link answers your question,

http://support.microsoft.com/kb/322692