Topic: SORT_IN_TEMPDB In meta data
Created an index with SORT_IN_TEMPDB = ON
I come into properties and I see False
I generate a script through CREATE AS... I see OFF
Through I look as the server gets meta data and I do not see anywhere something similar on sort in tempdb
Whether it was possible to learn from meta data with what value of this parameter the index is created? And generally why at creation ON I see False.....