• I guessed wrong (1024), such a natural number.... 😛

    It's really a trivia. no Google beforehand

    I still remember the discussion about max # of nonclustered indexes (which is 249), and how Microsoft came to that number is just... unknown. It's not 256, or 255.

    http://msdn.microsoft.com/en-us/library/ms189280(SQL.90).aspx

    The maximum number of nonclustered indexes that can be created per table is 249.

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005