SQL Server Index Fragmentation and Its Resolution

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 […]