29 lines (19 loc) · 657 Bytes

SQL Server Rule: SRD0003


Assembly	SqlServer.Rules.dll
Namespace	SqlServer.Rules.Design
Class	WidePKsRule

Rule Information


Id	SRD0003
Friendly Name	Avoid wide primary keys
Category	Design
Ignorable	false
Applicable Types	Primary Key Constraint

Description

Primary Keys should avoid using GUIDS or wide VARCHAR columns.

Summary

Avoid creating very wide primary keys with guids or (n)varchar as the first column in the index.