SA0050 : Do not create clustered index on UNIQUEIDENTIFIER columns

Do not create clustered index on UNIQUEIDENTIFIER columns

The rule checks database for tables having a clustered index on UNIQUEIDENTIFIER columns. Consider moving the clustered index to a different column or consider using <codeInline>NewSequentialId()</codeInline> system function for generating sequential unique identifiers. The native <codeInline>uniqueidentifier</codeInline> data type is not suitable for clustered indexing, because causes terrible page splits because its value is completely random.

Consider moving the clustered index to a different column or consider using NewSequentialId() system function for generating sequential unique identifiers. The native uniqueidentifier data type is not suitable for clustered indexing, because causes terrible page splits because its value is completely random.

The rule has a ContextOnly scope and is applied only on current server and database schema.

Rule has no parameters.

The rule requires Analysis Context. If context is missing, the rule will be skipped during analysis.

Design Rules, Bugs

There is no additional info for this rule.

Other Resources