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 »

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 »