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.