Using SQL Server 2012. I have a huge table that is partitioned. I need to create a non clustered index on it.
After I created the index, a job that somewhere switches partition fails because the index I create. (The job works fine once I remove the index)
My question is what are the things I need to take in account while creating the index on partitioned table.