September 29, 2015 at 11:04 am
I had someone ask what are the issues if you update data, disabling a FK, and then enabling without check. Can someone write a scenario or two to show the potential issues?
October 9, 2015 at 1:54 pm
Have you had someone submit an article for this? If not, I can take it since I need a new topic to blog on. Let me know.
February 9, 2016 at 6:00 pm
Bump
February 10, 2016 at 6:30 am
So I guess Lori stepped back?
I can write something about it, but you could also check out this first; http://sqlblog.com/blogs/hugo_kornelis/archive/2007/03/29/can-you-trust-your-constraints.aspx
(The blog post itself uses a check constraint to illustrate the issues, but an example that uses a foreign key can be found in the comments).
If you want an article specific about untrusted FKs, I'll write something up for you. Just let me know.
February 10, 2016 at 1:21 pm
I haven't heard from Lori.
I'd like something here on the topic, more along the lines of what's in your comments. IF you'd like to write something up, I'd appreciate it.
February 10, 2016 at 1:38 pm
Chris Bell wrote something on that topic here: https://wateroxconsulting.com/archives/untrusted-foreign-keys/
It doesn't get into the details of how it can change execution plans which is what I think you're looking for.
February 11, 2016 at 8:45 am
Sorry for the confusion. I was waiting for a note saying that no one else had taken the subject. Unfortunately now I am too busy to do the post so I will definitely step back. Sorry again!
April 27, 2016 at 9:35 am
bump
April 27, 2016 at 10:17 am
Steve Jones - SSC Editor (4/27/2016)
bump
Huh??
The article is written and already published. Not sure why you are bumping this?
April 27, 2016 at 12:38 pm
Sorry, mistake. Got tabs confused.
closing.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply