My MS SQL Server Articles

My MS SQL Server Articles

1. Indexes on Computed Columns: Speed Up Queries, Add Business Rules
Using an index on a computed column, you can implement complex business rules or just give your SQL Server queries a performance boost.

http://www.devx.com/dbzone/Article/30786/0

2. Avoid These Common Business Rule Implementation Mistakes
Some solutions for implementing business rules can allow invalid data to get into the database. Find out where the loopholes lie in these all-too-common approaches.

http://www.devx.com/dbzone/Article/31985/0

3.Index Covering Boosts SQL Server Query Performance
Index covering is a quick and easy solution to many query performance problems. By just adding a column or two to an index you can significantly boost a query's performance.

http://www.devx.com/dbzone/Article/29530/0

4. The Less SQL Server Sorts, the Faster It Responds (with Rajiv Rajak)
Learn coding techniques to tweak your SQL queries so that SQL Server sorts less data and returns much faster.

http://www.devx.com/dbzone/Article/30149/0