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...

Not perfect, but this should get you much closer:

SELECT 
    ReferencingObjectType = o1.type,
ReferencingObjectName = o1.type_desc,
ReferencingObject = SCHEMA_NAME(o1.schema_id)+'.'+o1.name,
ReferencedObject = ISNULL(ed.referenced_database_name, DB_NAME()) + '.' +
 ...

I'm a bit confused about "Return values" being plural.  Isn't there only a "return value"?  Yes, somewhat pedantic mood as well :-).

I could think of 4 rather easily, I'm sure there's more, as others have noted.

Be sure to specify "WITH (TABLOCK)" on the table being loaded.  It's not technically needed at 2016+ level but it doesn't hurt.

The very first page of a table that SQL...

• This reply was modified 5 years, 10 months ago by ScottPletcher.

If you don't have permission, you won't have permission period, but the command-line way to get the text is:

EXEC sys.sp_helptext 'view_name'

Here's the main article I was basing my comments on about minimal logging in SQL Server 2016:

https://sqlperformance.com/2019/05/sql-performance/minimal-logging-fast-load-context