I have a large database with size of 40 GB and a one of the main tables which have row count of 3763071 rows and name of "XXX" and that table has a clustered index which is the primary key
suddenly that clustered index got disabled and the queries stopped
and i have a huge concurrent access on that table
And i have a full text index which got disabled too on the same table
and when i opened the logs found that the sql got some updates just before that problem. I am using dot net framework 4.5 and entity framework as
sql server 2014 .so i'm asking what could cause that problem to avoid it again??
and one another question i have more than
25 index on that table
so is it bad or good to have that number of indexes which have repeated columns?