The real professional inspiration comes not from quantity but from quality. This becomes even more obvious by the thin book written by Rick A. Morelan and Pinal Dave on ‘SQL Performance Tuning techniques using wait statistics, Types and Queues’.

The topic is indeed one of the most often misunderstood and underestimated ones in performance tuning; and

It happens often. Too often, maybe. A DBA goes to a company, looks at the system, which is running slow and and the business people are losing faith in, and the DBA creates an index or two and the system starts performing 50 times better. And then everyone seems to be quite happy.

Powered by Good Will. (Will is the person who offers his sympathy to others together with ideas, but who does not give any guarantee about the completeness of the concepts or the immaculate perfection of the scripts on this site. Use this site to grasp SQL Server concepts and to get knowledge. )