Cacher is the code snippet organizer for pro developers

-------------------------------Rebuild Index of table-----------------------------
1.
USE <<DatabaseName>>;
GO
ALTER INDEX ALL ON DatabaseName.TableName
REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON,
              STATISTICS_NORECOMPUTE = ON);
GO
2.
sp_updatestats

----------------------------Shrink Database-----------------------------------------------------

ALTER DATABASE Insight SET RECOVERY SIMPLE
DBCC SHRINKDATABASE (Insight);
ALTER DATABASE Insight SET RECOVERY FULL