Code it Yourself…

A blog on Microsoft Azure and .NET by Carlos Mendible

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:

FROM sys.objects
WHERE type = 'U'
AND object_id NOT IN
(SELECT object_id FROM sys.indexes WHERE index_id = 1)

Hope it helps!