The following are my code standards, broken up by C#, and SQL, and should be listed alphabetically. This will be a growing and updated document.

SQL Code

/* Foreign Key */
ALTER TABLE [Schema].[ForeignKeyTable]
    ADD CONSTRAINT FK_ForeignKeyTable_PrimaryKeyTable
    FOREIGN KEY ( ForeignKeyColumn )
    REFERENCES [Schema].[PrimaryKeyTable] ( PrimaryKeyColumn )
    ON UPDATE NO ACTION ON DELETE NO ACTION
GO

/* Primary Key */
ALTER TABLE [Schema].[Table]
    ADD CONSTRAINT PK_Table
    PRIMARY KEY CLUSTERED ( IdentityColumn )
    WITH (
        STATISTICS_NORECOMPUTE = OFF,
        IGNORE_DUP_KEY = OFF,
        ALLOW_ROW_LOCKS = ON,
        ALLOW_PAGE_LOCKS = ON
    ) ON [PRIMARY]
GO