Find missing indices using dynamic management views in SQL Server
For SQL Server performance tuning, besides rebuild index and update statistics, often we also need to identify missing indexes. This can be done from SQL
Simplicity, patience, compassion. These three are your greatest treasures.
Some say that my teaching is nonsense.
Others call it lofty but impractical.
But to those who have looked inside themselves,
this nonsense makes perfect
