Saturday, February 9, 2008

Best SQL Server indexing strategies

Best SQL Server indexing strategies
Appropriate indexes can make a world of difference in performance. SQL Server supports only two index types for most data types — clustered and non-clustered. SQL Server also supports full-text indexes and XML indexes, but those are relevant only for specific data types.

Designing databases for performance (pdf)
Download (pdf)

No comments: