I'm not sure. You do the compare then go to Tools, Generate Report and look...

Redgate SQL Compare[/url] can do that and then export to XML for Excel. It can also export to HTML and a few other formats.

DISCLAIMER: I work for Redgate.

No, there's still no Best Practices Advisor for 2014. There is the 2014 Upgrade Advisor though. That will help you through the upgrade process.

There's no read/write on the secondaries. Not yet anyway. That's basically merge replication.

If the PK is the single most accessed path to the data, yeah, I agree, it should be clustered, testing or not. Although, I prefer testing and advocate for it....

If you do a search online there are lots of lists of recommended reading. I agree with the post above. I also regularly suggest Craig Mullins book, Database Administration, which...

homebrew01 (4/16/2015)

---

Thanks. Currently I'm working with a mix of 2005 & 2008 servers, so extended events won't work on 2005 (I think).

I'll read up on it for the 2008 servers,...

Sorry I wasn't clear. What Jason said. They need to either make it consistent or give us good documentation.

My assumption, based on both our tests, yes, it's changing between versions. Not that much of a surprise. Every version has a new optimizer. Why wouldn't there be tweaks to...

Add a few steps to the job then. First, disable the standard log backups. Then, have a second log backup job that runs more frequently. Enable that. Run your process....

You absolutely have sympathy. That sounds extremely painful.

When attempting to deal with this sort of problem, and it's extremely common, I always recommend that you document the pain. Get written...

And I was just coming back to check on this and set up my test. Thanks for posting that. It's useful to know. Curious, did you look at the plan...

patrickmcginnis59 10839 (4/16/2015)

---

The hash key is computed as (object_id * database_id) mod (hash table size). For plans that are associated with adhoc or prepared plans, the object_id is an internal...

I don't work for Microsoft, so I can't tell you anything about the internals behind the scenes. However, from what I can see, they have changed the hash formula. I...

It's not a minor issue. This is evidently taking servers completely offline. I would absolutely NOT install Sp1 until we get much more complete explanations from Microsoft.