Optimization SQL Server … October 17th, 2003

Vinod Kumar

Even though I’ve seen numerous documentation that say SQL Server is self optimized, I agree to these words to some extend only. There are tons of optimization that a DBA has to take to make maximum use of their harware setup … The various optimization techniques available are like:

1. Data Optimization : Includes table design, View design etc.

2. Storage Optimization : Including HDD, RAID, File groups etc.

3. Code Optimization : Often developer are keen on the functional approach and not the optimized approach.

4. Server Optimization : Includes various server configurations and settings.

Each of these topics can wrap up our understanding and writing optimized code in SQL Server 2000 … Feel free to ping me and give your inputs on the same anytime … :)

You can catch some of the better coding practices available in my article : http://www.extremeexperts.com/sql/articles/BestPractices.aspx



This entry was posted on Friday, October 17th, 2003 at 16:40 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply