Summary

Getting good performance out of SQL Server is not as hard as many people believe. It's largely a matter of knowing what tools are available to you and knowing a few small tricks of the trade. In this chapter, you saw some tricks related to SQL Server. You also learned about some tricks and performance issues with different objects of ADO.NET.