What type of Replication you are using? Is the Data replicating to distributor?

Is there any input parameter for Query?

Create an Clustered index. Try to minimize the no of non clustered by creating include indexes.

Check AUTO_CREATE_STATISTICS

Using Replace is good logic and it will be faster

You better maintain two for each loop so the process will be faster

Please check following URL:

http://sqlblog.com/blogs/louis_davidson/archive/2007/07/22/sys-dm-db-index-usage-stats.aspx

You can run check point on any database.

The performance impact of using checkpoint_duration depends on the number of dirty pages, the activity on the system, and the actual duration specified....

Please read the following URL:

http://databases.about.com/od/sqlserver/a/free_sql_server.htm

Please check the following URL:

http://blogs.msdn.com/b/grahamk/archive/2008/12/08/database-mirroring-error-1418-troubleshooter.aspx

check the following URL may be useful to you

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/a49fc6d8-7631-4d74-a2fa-7c4211dbcac6

You can only exprot the data and use.

The following URL will help you more

http://blog.sqlauthority.com/2008/02/23/sql-server-2005-understanding-licensing-model/

What is the edition your are using?

Keep SSRS and SSIS to one box and put SSAS on its own as it is more resources intensive.