helpful rebuild your indexes script

rebuild.sql

SELECT name, OBJECT_NAME(a.object_id), avg_fragmentation_in_percent, 
 'ALTER INDEX ' + b.name + ' ON ' + OBJECT_NAME(a.object_id) +' REBUILD WITH (STATISTICS_NORECOMPUTE = ON)' as command
FROM sys.dm_db_index_physical_stats (
       DB_ID(N'PrePurchasing')
     , OBJECT_ID('PrePurchasing')
     , NULL
     , NULL
     , NULL) AS a
JOIN sys.indexes AS b 
ON a.object_id = b.object_id AND a.index_id = b.index_id
order by avg_fragmentation_in_percent desc