Top 10 steps to optimize data access in SQL Server: Part III (Apply advanced indexing and denormalization)

Al-Farooque Shubho

Rate me:

4.92/5 (80 votes)

8 Jun 2009CPOL16 min read

190.1K

172

As part of a series of articles on several data access optimization steps in SQL Server, this article focuses on using some advanced indexing techniques and using de-normalizations to optimize data access.

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

No alternatives have been posted.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Al-Farooque Shubho

Founder SmartAspects

Bangladesh

I write codes to make life easier, and that pretty much describes me.

Top 10 steps to optimize data access in SQL Server: Part III (Apply advanced indexing and denormalization)

Alternatives

License

Comments and Discussions