I have following two questions:
I have a SQL Server index with the following options:
PAD_INDEX = OFF STATISTICS_NORECOMPUTE = OFF SORT_IN_TEMPDB = OFF DROP_EXISTING = OFF ONLINE = OFF ALLOW_ROW_LOCKS = ON ALLOW_PAGE_LOCKS = ON FILLFACTOR = 70
Where are these details are stored in the database? I have found tables like
sys.statswhere a few of these options are stored. I need the complete list, if possible.
To partition an index in SQL Server, we need to drop it and recreate it by associating it with partition scheme. Is this the only way to apply partition on an existing index?