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.

You must have a primary key or a unique constraint in one table in order to match that table to another through a foreign key constraint. Further, the data types...

No. There's no log file showing temporary table creation and drops. Also, you can't reference a standard temporary table between sessions. You would have to create a global temporary table...

Or, check out Minion Reindex which is available here[/url].

Assuming your maintenance plan is being run by SQL Agent, you can try outputing everything from Agent to a file. It's a...

Pretty sure it's microseconds on rpc_completed and sql_batch_completed. However, it does depend on which event you're looking at. Unfortunately, Microsoft has been inconsistent and hasn't documented well. Vote that up...

Do you mean maintenance scripts?

If so, go here. You can see a number of different utilities for index maintenance, backups, and all sorts of other things.

Then I'm not sure I understand what's happening. sorry. Can you post a screen shot or two with the list? Hide the names if you need to. Or, you might...

No, that would show up as differences. Have the table names and or schema's been changed? If they're named differently, our tool can't figure out that TableA ought to be...