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:

1SELECT name
2FROM sys.objects
3WHERE type = 'U'
4AND object_id NOT IN
5(SELECT object_id FROM sys.indexes WHERE index_id = 1)

Hope it helps!


netDumbster another .Net Fake SMTP server based on Dumbster
Prepare your App for Windows Azure! Create a custom Configuration Manager!
comments powered by Disqus