I am new to sql dba and I just want to know when to createclustered indexes and when to careate non-clustered I have knowledge on thesetypes of indexes But I am in dilemma…pls somebody help me in this.
Again this sounds like a classroom or interview question. http://www.sql-server-performance.com/articles/per/index_data_structures_p1.aspx fyi and make sure you post the questions in correct section.