what is clusters and indexing in sql [Resolved]

1.A cluster is a schema object that contains data from one or more tables, all of which have one or more columns in common.
2.Clustering can be best described as a technology that automatically allows one physical server to take over the tasks and responsibilities of another physical server that has failed
3.Clustering can increase reliability and uptime in a client/server environment.
4.An Active/Passive SQL Server cluster refers to a SQL Server cluster where only one instance of SQL Server is running on one of the physical servers in the cluster, and the other physical server does nothing, other that waiting to takeover should the primary node should fail.
5.Clustering doesn't save you space or effort for backups or maintenance. You still need to do all of your maintenance as normal.

Yugandhar, if this helps please login to Mark As Answer. | Alert Moderator

Refer this url
http://www.dotnetfunda.com/articles/article177.aspx

Yugandhar, if this helps please login to Mark As Answer. | Alert Moderator

Hi,
refer this link
http://www.codeproject.com/Articles/173275/Clustered-and-Non-Clustered-Index-in-SQL-2005

Thanks & Regards
Hari

Yugandhar, if this helps please login to Mark As Answer. | Alert Moderator

Hi Yugandhar,
Please Mark as Answer if it helpful to you..That helps others who search the same...

Yugandhar, if this helps please login to Mark As Answer. | Alert Moderator