tl;dr - see last paragraph. CREATE TABLE [dbo].[AttachedFiles]( [ID] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ReferenceLocation] [varchar](255) NOT NULL, [FileName ...
Updating fact rows inside a star schema set of tables is never a best practice. Even so, some organizations travel down this path. Consultants occasionally will go so far as to embrace the idea of ...