It’s the beginning of a new year. A new start, a new dream, a new resolution! […]
Sailing into 2021
It’s the beginning of a new year. A new start, a new dream, a new resolution! […]
[…]
[…]
[…]
The 2020 has been a tough and bumpy year for most of us. Finally it has come to the end. Looking back, there are many moments to be remembered. We experienced the worst pandemic lockdown; Kids had the longest no-school days; Working from home became new normal for most none essential workers. And the list […]
[…]
The 30th of December, it was a very peaceful morning. At the lake, the trails have been fully covered by a thick layer of white snow. There are a lot foot prints left on the snow by early joggers , dog owners and their dogs. Near the water, the tree brunches that hung over the […]
[…]
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 […]
[…]