Clint (7/23/2009)

---

Thanks for the reply. However, I don't see how striping the backups across drives will help. Currently, space is not an issue for us. Also, due...

A third option would be to speed up the backups and restores, either through third-party compression or by striping the backups over multiple drives; it has the added benefit of...

I'd leave the pagecount alone. Small tables just don't benefit a great deal from rebuilding / defragmenting, and really small tables will be split over multiple extents by default.

Did...

You should be able to set up the alert based on the scripts in that link. The alert can be set to generate the emails you need, and can...

Certifications may be mostly worthless, taking the certifications is not. The exams (for DBA at least) cover a wide range of topics; if someone spends the time and understand...

Look at http://msdn.microsoft.com/en-us/library/ms174411(SQL.90).aspx and set the server name. That may resolve your problem.

Although you may have seen a recommendation of <10 databases for mirroring, it isn't really accurate. More important is the availability of resources to handle the mirroring, especially the...

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

I think you want an alert on mirroring state 8.

I considered this scenario at one point. The biggest factors in deciding to keep each client in it's own database were:

1) database size and ability to manipulate / backup...

Your trigger looks to be doing something that a foreign key could accomplish; any reason to use the trigger at all?

Back to the original topic, I second Gail's advice with one exception - if your testing includes performance then a plain backup/restore approach may be better as there is a...

Agree with the above. They are perhaps the most responsive company I've ever dealt with.

The native syntax is one of the biggest selling points to me - no need...

Is the update statement alone inside a transaction, or does the transaction encompass other processing? Does it have to update a large number of rows? Is it being...

In that case can you tune the other proc so that it doesn't hold the locks for as long? If not the alternatives that I can think of are:

1)...

You probably should start with identifying the cause of the timeouts - check the waitstats before and after the maintenance window, also monitor the perfmon stats and compare to baselines...