SQL Azure Requires Clustered Indexes in all tables
Recently we performed some test against SQL Azure. We found that our system was throwing an exception cause SQL Azure requires a clustered index in each table (Wanna know why?).
So how can you find out what tables are causing the issue? The answer is simple, run the following query and you’ll have the list of tables to fix:
SELECT name FROM sys.objects WHERE type = 'U' AND object_id NOT IN (SELECT object_id FROM sys.indexes WHERE index_id = 1)
Hope it helps!