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 Tuning Advisor, but I personally feel it’s quicker to directly query the dynamic management views. Here is a sample query I normally use to identify and generate index creation scripts […]

Read More…

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 sense.And to those who put it into practice,this loftiness has roots that go deep. I have just three things to teach:simplicity, patience, compassion.These three are your greatest treasures.Simple in actions and in thoughts,you […]

Read More…