Will REORGANIZE and SORT_IN_TEMPDB work in SQL Database V12 ?

Hi All,

We are planing to implement Index immanence in SQL Database V12 version,

Please let us know  below statement will work in SQL Database V12 ?

FILLFACTOR,REORGANIZE,SORT_IN_TEMPDB and SELECT ..INTO.

Please some body provide the index maintenance script on SQL Database V12.

Please refer the Microsoft links which can help us to understand index maintenance .

Regards,

September 10th, 2015 8:54am

Hi All,

Below link is saying 

http://beyondrelational.com/modules/2/blogs/76/posts/15290/index-fragmentation-in-sql-azure.aspx

FILL FACTOR,REORGANIZE,SORT_IN_TEMP DB and SELECT ..INTO won't work for SQL Azure ? but not mentioned which version it is  ?

Please some body help us with Index maintenance script  for SQL Azure..if possible.

 

Free Windows Admin Tool Kit Click here and download it now
September 10th, 2015 10:18pm

I think you got the answer for this right?

http://blogs.msdn.com/b/dilkushp/archive/2013/07/28/fragmentation-in-sql-azure.aspx?CommentPosted=true#commentmessage

September 11th, 2015 3:22am

Hi Dilkush,

Thanks for update.

Free Windows Admin Tool Kit Click here and download it now
September 11th, 2015 4:22am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics