SQL Server Clustering Interview Questions 

i have a table with 10,000,000,000 records and i need Select and Insert many records from or into this table in less than one second.
i can't buy a very expensive hardware(Server) for my SQL Server 2005 but i can buy many medium price hardwares(Servers) for my SQL Server 2005.
how can i distribute or cluster this table trouhg many hardwares(Servers)?

When clustered and non-clustered index ( in SQL SERVER ) should be used ?


And what is correlated subquery ? Example please.


Thanks in advance.

*Creating a New SQL Server Cluster
*Install Cluster service on at least one node & run it before installing it on another node.
*Do not install Cluster service when multiple nodes are running & connected to the shared storage device at the same time, with Cluster service running on neither.
*After you have installed Cluster service, you cannot change the computer name of either node in the cluster.
*You should not use WINS database static entries for cluster nodes or cluster addresses.
*You must not configure cluster resources to use unsupported network protocols or related network services such as Internetwork Package Exchange (IPX), NetBIOS Enhanced User Interface (NETBEUI), Data Link Control (DLC), Appletalk, or Services for Macintosh. Microsoft Cluster Server works only with the TCP/IP protocol.
*You must not delete the HKEY_LOCAL_MACHINE \System \Disk registry key while the cluster is running or if you are using local software fault tolerance.
*Installing and Configuring the Hardware, with pictures:
http://www.microsoft.com/technet/archive...
--------------------------------------...
Configuring the First Node, Step-by-Step Guide to Installing Cluster Service: (http://www.microsoft.com/windows2000/lib...
--------------------------------------...
Validating the Cluster Installation, Step-by-Step Guide to Installing Cluster Service (http://www.microsoft.com/windows2000/lib...

Dear all,
I have two windows 2003 Servers with 70 clients. First one is DC and also have Active Directory. On the second one there is data base Sql server 2005. I want to make clustering btwn them.
Plz give me the details how to implement it.
I will be very thankful.

I know 2 SQL Server machine can connect together using clustering so that when one macine breakdown, the SQL Server will fail over to another machine automatically.

Anybody can send me a picture(s) that show me two machines share the disk arrays using paralle SCSI? i want to see a picture how paralle SCSI connect disk array to two machines.

Thank you very much