SA0050 : Do not create clustered index on UNIQUEIDENTIFIER columns
The topic describes the SA0050 analysis rule.
Do not create 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.
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.