BTW, I agree with what everyone else is saying. Of course you should be deleting the data in such a way that you're not violating referential integrity. It's there for...

For DELETE and UPDATE operations, you can't simply disable the constraint by using NOCHECK. Instead, you have to drop and recreate the constraint. Just be sure that when you recreate the...

Can you have an availability group across two different failover clusters? Yes.

The issue is, generally, AG is meant as a replacement for failover clusters. Unlike failover clusters, there...

Have you looked at the execution plans to understand how the optimizer is choosing to resolve the query? Can you capture the actual plan (although, an estimated plan would work...

My, very general, rule is that the clustered key should be on the column or columns most frequently used to access the data. In many, probably even most, cases that's...

Off the top of my head? No. I'd want to go back & reread the relevant sections of Kalen's book to be able to answer your question with even a...

Man, Jeff. Leave some crumbs for the rest of us.

Generally, when trying to troubleshoot performance issues, you start with identifying where the issue is coming from. You've done that. Next, before we start talking solutions, we need to understand...

So PLE is just measuring how long a page lasts in memory (it's an average, obviously). So a page of data from a lookup table used in lots of different...

You can use replication. Microsoft has great documentation on how to set it up. That's about your only option for going Azure SQL Database from an on-premises database....

It's going to halt the execution.

I'd put extended events on the job to monitor for procedure start and finish. If you have an unmatched pair, you've at least...