File fragmentation in SQL Server

How physical file fragmentation in SQL Server can cause database performance issues and how to monitor and resolve the file fragmentation.

File fragmentation? What file fragmentation? A few years back a SAN admin told me not to worry about physical file fragmentation because “The SAN takes care of it” and I took them at their word and, probably along with a lot of fellow DBAs who have their back-ends (in a manner of speaking) on  a […]