It's the insert and update that are locking the table.

You can ignore these locks by using the nolock hint:

select count(*) 
  from mytable with...

Yes, that is common but horrible, but at least it would not affect the logical design, which could still be forward engineered to proper physical form.  Just keeping accurate logical...

Sure, you could do a design with only pencil and paper, just as you can eventually get across town by walking.  But for anything but the most trivial design, you...

I suspect you many not need individual dates in the result at all.  I also adjusted the range to 7 days rather than 8, as a week seems like a...

SQL's Query Cost Governor is all that I'm aware of toward that end.  This is a before-execution, based-on-estimates governor, so it's not 100% accurate.  But hopefully it would prevent anything...

The single most important thing to understand, though, is that data modeling is a logical process, not a physical one.

Physical things -- identities, files, etc. -- do not exist in...

ERwin is great, one of the best tools I've ever used, but it is expensive.

An excellent feature to look for is a "data dictionary" / "data element" component.  That is,...

>> Since the incoming sales order notes will not have the same PK (NoteID) value as before (due to an auto-incrementing PK) <<

Turn off the auto-incrementing for the rows you're...

No.  CHECK does not go across rows.  You will need an index or some other multi-row method.

Whether the number must be NULL or NOT NULL can be done with a CHECK constraint:

CONSTRAINT data__CK_1

CHECK(CASE WHEN letter_column = '1e' THEN CASE WHEN number_column IS NULL THEN 1

ELSE 0...

I don't believe the inserted table (view), which is current data, could be created from a version store, which is historical data.

We can certainly prove that with...

My inclination would be to move the char(7200) to a different table.  Or, depending on the specific circumstances, change it to varchar(max) and force it LOB (out of the main...

First, can someone speak to the premise that the entire row is updated when updating one column?

No.  Only the modified column(s) are updated.

Is this a good suggestion? What are the...

Is the view reference directly in the code or is it some type of generated / dynamic SQL?  Naturally the view can only give references for the code that is...