Category: "Useless for most people..."
Found prove that SQL Server is the Devils Engine - ERROR 666
Msg 666, Level 16, State 2, Line 1
The maximum system-generated unique value for a duplicate group was exceeded for index with partition ID 1234567890.
Dropping and re-creating the index may resolve this; otherwise, use another clustering key.
It… more »
1 comment »
increasing the performance of count(*)
The fastest count(*) can be archived if you create a secondary index on top of a clustered index only containing the clustered key Carefull this is an index that will be used only here ... more »
