Lack of index on FK column has bitten me when the parent table was one where the data was occasionally deleted. Deletion of rows in the parent table necessitated...

More applause.

Thanks for this article. Good stuff! I like your solution.

I haven't encountered this before, but quick internet search indicates your problem is mismatch of disk physical sector size between your nodes. Check . Might not be trivial...

Guess I was wrong! Sorry. Well, I think that's a good test case anyway, takes any special ATTACH considerations out of the picture.

Weird error. Using...

I think this question needs clarification. SSMS can "see" your Z: drive, can't it? Use File | Open file and check if you can't browse your Z: drive. You...

FWIW - We have successfully used same method proposed by Kristen-173977 for many years, for both batched DELETEs and UPDATEs. The only difference is we explicitly CREATE the #keys...

Great article.

Good article! Thank you.

All--thanks for the kind words. Mister.magoo--point well taken. I will preface with a summary if I ever write another one of these.

Over 3 yrs ago we replaced most of our replication with a readable AG secondary replica. We have never regretted this. Replication worked ok, but was much more...

Interesting and well written, but I disagree with your slant.

Much of this article is based on assumption that your DR instance is providing HA. In my experience, with...

Very good article, great solution! Thank you.

Great idea, thanks for writing this up.

I concur. Nice job! Thank you for this.