Unfortunately there are some differences between SQL Server and SQL Azure. One of these differences is that SQL Azure does not support the “DBCC DBREINDEX” command. Thankfully there is an alternative you can use to rebuild the indexes within your SQL Azure databases. The alternative is to use “ALTER INDEX” instead. ALTER INDEX ALL ON TableName REBUILD
Here’s an example that loops through all the tables in a database and rebuilds all their indexes:
DECLARE @TableName varchar(255)
DECLAR...
[More]
e4ba6b86-79cc-4d7d-81d0-f53e35dff7ca|1|5.0
SQL
sql, azure, database