De-Fragmentation (Database Maintenance scripts in general) must be used in replicas as well as in the primary.

NICE!

You should check for Blocking, Recompilation and table statistics problems.

I think you want to probably capture an SQL "trace" and then replay it on the "development" database at will.

Use "Linked Table Manager" in MS Access Front-End

You should take transaction log backups while this is running to avoid log autogrows which could slow you down even more.

SQL Server Backup files compress very well. Log Shipping is probably appropriate for you.

No. If you restore on a new server all replication settings are lost.

It has been my experience that this things happens *A LOT* with the Standard Edition (no lock pages in memory) when other than SQL Server Apps are running on the...

By any chance is this happening while you are "COPYING" files across the network ?

I would do all the "IF...THEN" on the "Client" and call the appropriate proc on the server directly.

bvansickle (12/1/2008)

---

I've done 95% of my development in MySQL in the past, but I have to use SQL Server 2005 for the project I'm working on now, and I was...

Jeff Moden (11/18/2008)

---

Heh... you guys are missing it... OP wants to know why performance IMPROVED so much after the upgrade so they can go back to the original database and...

KATHLEEN Y ZHANG (11/17/2008)

---

Hi, MSDN article

http://msdn.microsoft.com/en-us/library/ms151196.aspx

says that:

The following actions require the system to be quiesced. This means stopping activity on published tables at all nodes and making sure that...

You must monitor tempdb growth. When all working tables are disposed and at off hours you can use ALTER DATABASE to get tempdb back to a normal size. You should...