Because he wants the cities where there's no row for that city with the...

To where? Snarky...

I suspect Phil meant to apply the traceflag just to the problematic query, not enable it system-wide.

https://support.microsoft.com/en-us/kb/2801413

https://blogs.msdn.microsoft.com/psssql/2015/06/16/identifying-sql-server-2014-new-cardinality-estimator-issues-and-service-pack-1-improvement/

YSLGuru (8/23/2016)

---

We don't need to do backups of the log because the entire server is on a DR systems so that if anything happens the entire server is restored. ...

No. Anything that's minimally logged in bulk-logged is minimally logged in simple.

szejiekoh (8/23/2016)

---

Actually, what i am trying to clarify is that a 2 node WSFC will still need share disk (fileshare aside) for voting/quorum even though always on availability group sitting...

I was fully expecting to get a reply like "Tried that and it won't start!!!!"....

Backups that are on the same...

Why?

If you want to shred it, why not use XPath...

You can check the previous error log to see why it stopped

Start the service?

Could be the deadlock hasn't reoccured.

You don'yt need 1204, that the SQL 2000 traceflag for capturing deadlocks, and to be honest you don't need 1222 in SQL 2012, use the...

SELECT CityName FROM @Cities where CityName NOT IN (SELECT CityName from @Cities WHERE StateNAme = 'ALL');

Edit: And make sure that CityName is not nullable column.

You don't need any exporting, or importing, or discrepency checks. While you can't do an in-place upgrade, that's probably not something that you want to be doing in production. Side-by-side,...

The USE PLAN hint, but I would recommend you try every other way to get a desired plan shape first. The hint's not one I like using in production.