The "Agent XPs disabled" is usually a symptom rather than a cause - it's what you see when SQL Server Agent isn't running.  The SQL Agent Error log is the...

If the foreign key constraint is stopping you from dropping the table, you'll need to drop the constraint before you start and re-create it afterwards.

John

Changing the option only applies for new rows.  The rows that were in the table before you changed the option will stay where they were.  Could that be what's happening...

Richard

What indexes do you have on that table?  Do any of them have a max column as part of the key?

John

Liam

Without seeing your table and the data in it, it's difficult to advise.  If open cases have a null completion date, then just do WHERE CaseCompleted IS NULL.

John

How are we going to know where to put the spaces?  Unless you have a full databases of street names for the all the areas you cover, I don't think...

xml is the best data type, so that you can easily shred the deadlock graphs to make them understandable.  By the way, I recommend you capture deadlocks more often...

1. Have you tried querying the DMVs whose names begin with "sys.dm_xe"?
2. You can have this for free.  I think I got it off the internet a while ago, but...

Does this help?

John

Who'd have thought you'd get deadlocks with Entity Framework?!

It's documented here.  You want to set deadlock priority for HIGH for number 2 if you don't want it to be...

Are the two servers part of the same WSFC (Windows Server failover cluster)?  I think that's a pre-requisite for availability groups.  What exactly are you trying to do when you...

Yes, it includes all operations done in the database.  There may be some operations done to the database (such as ALTER DATABASE statements, which are run at server level) that aren't included,...

By "physical", I take it you;'re referring to DDL changes as opposed to DML?  The answer is yes - DDL and DML changes all go through the transaction log and can...

CAST the whole thing as decimal(10,2).  That'll give 0.67; if you really need 0.66 then CAST to varchar to chop the end off, and CAST back to decimal.  Alternatively, you...

I imagine you want your WHERE clause to be something like this:

WHERE SDate > '20190101'
AND EDate > '20190101'