Are your tables highly fragmented?

The London server would remain a mirror and it will remain in a disconnected state until you do something manually or the connection resumes (at which point it will sync...

Jeff Moden (6/14/2009)

---

Understood. My point is that I wasn't sure if the OP was going for a continuous "forever" log or just wanted a single log with the results...

Is the max value always going to be in the last partition? If so, you should be able to substantially speed up the query by using the $partition function.

You would have to check BOL (or try it) to be certain, but I'm fairly sure that you need to drop it first.

Not sure why it would take 20 minutes, we can look at the execution plan if you want to post it (.sqlplan format please). I can only assume that...

You have two choices at night :

1) drop and recreate the existing snapshot (which will obviously disrupt reporting, albeit briefly)

2) create a new snapshot and direct reporting users to this;...

I believe that they are accurate to the last server restart. You should consider whether there could be any annual, irregularly scheduled, or adhoc processes that may use those...

In addition you can attempt to recover the remaining transaction log entries and apply them to the log shipping backup after the other log backups have been applied.

You may have followed the other link to http://msdn.microsoft.com/en-us/library/ms189940.aspx which lists a few limitations.

It mentions performance, and although there should be no noticable impact to creating the snapshot, you should...

Even if being on different drives made a significant difference, it would presumably be as easy to move the tables to a separate filegroup in the same database rather than...

I looked at this post the other day, then thought for a while, then started to type, then decided that I'd be guessing anyway. But since you reminded me...

I wouldn't think so outside of general resource issues. You should take a look here:

http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Performance_Tuning_Waits_Queues.doc

It can help you to identify the primary reasons why a server is slower...

I saw your other post afterwards, and you should follow Grant's advice in creating baselines. Between perfmon stats, wait stats and DMVs there is a wealth of information that...

Was it a small number of peaks? It could be explained by, for example, a backup running. Note that this counter isn't SQL-specific so other apps could cause...