Have a look through this, and post back if there's anything in particular that you don't understand.

John

Well, if somebody has set up a server with (at least) eight processors and maxdop 1, I would suspect that they might not know what they're doing.

If the backup is...

Please will you show us what you've already tried?  Have you looked into PIVOT?

John

I typed "Always On feature list SQL" into my favourite search engine and I found this.

I don't know where you'll find information for SQL Server 2012 now it's no...

Have you tried using the installation media to do the uninstall?

John

You've got four columns called id in your query, and you haven't specified which one to use in your ROW_NUMBER call.  Replace "id" with "a.id", "b.id", "c.id" or "d.id".

John

Yes, and a history of the changes that have been made (date, person, description of change).

John

I think if anyone tried to reverse engineer the query from the execution plan, they'd lose the will to live!  Don't get me wrong - the execution plan is indeed...

Could it be blocking?  I know you said you're the only one doing anything, but could there be background processes or jobs that hold locks on the table you're querying?

John

Maybe 20 seconds is fast.  Care to provide more information, please - query, execution plan, table DDL, SQL Server version and edition, server RAM, max server memory, no of processors, maxdop,...

Have you looked at the definitions of those two views?  You may be able to tweak the code so it works better with the "new" query optimizer.

John

I suppose it's possible that the query recompiled after you created the index but the query optimizer chose not to use the index.  If you examine the graphical plan do...

Can you post some table DDL (CREATE TABLE statement), sample data (INSERT statements) and expected results, please?  I'm a bit confused, for example, about whether 2300 + 0900 should be...

1. No
2. It's there in case you need it.  You just need to bear in mind that each recommendation is based on the execution of a single query - it...

As I understand it, auditing is set up at the instance level, not AG level.  So if you can't see any events in the audit log for AG3, I think...