what is clusters and indexing in sql [Resolved]

Posted by Yugandhar under Sql Server on 8/22/2012 | Points: 10 | Views : 860 | Status : [Member] | Replies : 4
hi friends,
can any one explain---
what is clusters, and how it is different from views,when we will use clusters and what is need..

thanks in advance.




Responses

Posted by: Muhsinathk on: 9/13/2012 [Member] Bronze | Points: 50

Up
0
Down

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

Posted by: Ranjeet_8 on: 8/28/2012 [Member] [MVP] Gold | Points: 25

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

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

Posted by: Hariinakoti on: 9/13/2012 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Muhsinathk on: 9/14/2012 [Member] Bronze | Points: 25

Up
0
Down
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

Login to post response