How to identify and solve the fragmentation in SQL Server?

How does fragmentation occur in SQL Server? If there is an index on the object, the data is ordered in the page using the slot array. When a new insert comes, SQL engine will search an available page to keep the data by using the index. The data should be saved in the specific page…

2