Hi,
I have read lot of articles on SQL Server 2005 clustering and find out that
the SQL Server 2005 doesn't support Active/Active clusters out of the box.
But some techniques exist like Data Dependency Routing using Distributed
partition views etc.

Actually, i want to design architecture of a highly scalable web site that
supports 100,000 hits simultaneously. For this i am planning to create a
server farm (3 Web Servers) and will use NLB (Network Load Balancer)
service of Windows 2003.

But as you know, databases always bottle neck when you talk about high
availability & scalability so i want to know what is the recommended
architecture of Database to support this design?

How can i distribute database on multiple server (like 3 DB Servers) and
allow load balancing between them?
What is the recommended web server routing technique? (NLB VS any other load
balancer like Foundry ServerIron Load Balancer) and what is the advantages
of using NLB?

Regards
Adi