kaplan71 (3/10/2013)

---

A colleague of mine suggested that a trigger could be created that would monitor the transaction logs for entries that recorded any changes in the database. This trigger could...

If server maxdop is 0 then it's pointless specifying maxdop on the index unless you want to reduce the number of processors it is allowed to use.

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1429193-2799-1.aspx

Profiler or Extended Events (or a 3rd party tool that will use one of them)

Syncing the jobs is the easy part, just copy them to the other servers. You just need some check in the job to ensure that it won't run on the...

A single update statement can only update a single table, that's in any version of SQL Server

Just the jobs? What about the databases those jobs connect to? What HA/DR do they have set up?

Did you check out the blog post I referenced?

Profiler or extended events. Bear in mind you're looking at large volumes of data. I have a moderately busy server that, just by capturing what a user runs, generates 300MB...

Could you be more specific? Fail over when, to what, etc.

Unless the server maxdop setting has been set to something other than the default (0), that won't have any...

How could there be less data between '2013-01-01' and '2013-01-31' than there is between '2013-01-09'...

Direct manipulation of the sharepoint database will void your support and may break sharepoint if you're not careful. Any manipulation of the sharepoint database should be done through the sharepoint...

Full and log backups don't block each other (since SQL 2005), don't know about diff and log.

This perhaps

http://sqlinthewild.co.za/index.php/2011/03/22/statistics-row-estimations-and-the-ascending-date-column/