I do like to spend time to design better early on and do various tests to confirm i am on the right track.

And doing so by making mini-scripts and specific...

This article triggers a modeling thoughts in me.

Lets categorize some FK relationships first:

1. Collections such as order-lines in an order, or class members in a class.

Objectively we can say these...

It might be my memory...

I distinctly remember that in the past any function used in a constraint needed to be deterministic.

Querying a table violates that rule, obviously.

When did this change..or...

Thanks Jeff,

I also entered a PM session with ChrisM and he brought up a related problem that I think I just solved as well :).

If you want to know details,...

Even with some of the harsh feedback that comes with publishing I feel the need to write at least one article myself.

Certainly I owe many of the previous writers that...

TomThomson (3/30/2015)

---

peter-757102 (3/30/2015)

---

The forum ate my post due to a parsing error...grrr...not going to type it all again...just this:

Set types and scalar types follow different logic and sets are not...

The forum ate my post due to a parsing error...grrr...not going to type it all again...just this:

Set types and scalar types follow different logic and sets are not null-able, nor...

Gary Harding (3/26/2015)

---

Solomon Rutzky (9/4/2014)

---

Jeff Moden (9/3/2014)

---

I guess I'd have to disagree. Nulls mean "Unknown" and it is definitely known that there are no values on either side of...

It seems I disagree with both of you on all points then.

These are my most critical reasons for doing so:

The target audience are the database people, not the code people...

Solomon Rutzky (1/20/2015)

---

So who would create a library and not be a stakeholder?...

I agree with the OP.

Why does code need to be maintained as .NET assemblies by parties that likely are no stakeholder?

Why not create a type/class of stored procedure that uses...

During development writing code is only part of the story.

What I usually do is spend significant extra time in the data modelling phase.

With respect to performance, primarily how the data...

TheSQLGuru (12/11/2014)

---

Plan guides don't help with data-value-skew-induced poor performance resulting from a good plan for one input(s) being a (horribly) bad plan for other input(s) either.

I suppose we...

TheSQLGuru (12/11/2014)

---

One solution is to add to the particular sensitive query an "optimize for" hint and supply a known value that gives the desired plan.

Or use "optimize for unknown", so...

Excellent analysis and excellently written article.

One solution is to add to the particular sensitive query an "optimize for" hint and supply a known value that gives the desired plan.

Or use...