I wanted to write an article on Choosing the right columns for Clustered Index and Why it is so important? This becomes extremely important for an intensive read/write DB.
It will cover :-
1. What is Clustered Index?
2. Why to always have Clustered Index? What can happen if we will not have it?
3. Various locking in absence of Clustered Index
4. Hard Delete vs Soft Delete... Which to choose and why?
5. (Key lookup + Covering Indexes) vs (Clustered Index)
6. Requirement vs Best practices in choosing the right column for the Clustered Index
Please share your feedback and let me know if i go ahead with this?