A really important and interesting post I wanted put out lately. A topic which I would say is a basic core concept but I was surprised how so many people (read DBAs) were wrong about it. Why can't we have more than one clustered index on a table.
I got many interesting answers for it in many interviews i took recently and some of them I tried to debunked in this blog too and tried to clearly establish on, why we can't have more than one clustered index and what exactly physical sorting means. So read on and enjoy.
Happy Learning!
