The most attractive application can be extremely frustrating to use if its performance is less than acceptable. As a developer, you must take precautions to try to assure that the SQL Server is as lean and efficient as possible. This lesson explains:
How to select and tune your hardware
How to configure and tune SQL Server
How to maintain your databases
How to maintain your tables and other ...