Rebuild indexes in SQL Server 2005

If you have a database with millions of records on which you provide search facility to customers then you will need to maintain indexes so that the visitor experience is enhanced. SQL Server 2005 allows you to create indexes. Its up to you to decide which columns should be indexed. Most probably those columns should … Read more