It’s really easy to answer the interviewer question “How to know index fragmentation?” and “what you will do to resolve the issue?” It’s always a situation with Production DBA’s how to find index fragmentation and in case they are lucky enough to find out they are confused its internal fragmentation or external fragmentation. What to […]