This script didn't work on a sharepoint server because of the awful long database names sharepoint uses.  Enclosing the "Use" [DatabaseName] in brackets [] fixed this problem.  On 2012 (at...

Nobody has any comments?  Genius?  Completely off my rocker?

Isn't that what query hints are for?

"Optimize for" usually helps a lot in these situations.  Dynamic sql would still be my last choice to handle performance problems.

We setup an AlwaysOn configuration on one of our production servers as a test and ran it for 6 months.  For our system the expense, complexity and maintenance of AlwaysOn...

It even works at 4:00am during a really hectic upgrade!!! Thanks!!!!

Thank you!!!!