Clustering configuring

Hi all,
I'm new to clustering. Is there any website on how i could learn to
configure clustering.
I have 2 new servers(Svr1 & Svr2) and san storage. On Svr1 i'm going to
install Win 2003 and sql 2000. Svr2 is going to be application server(dfs,
VB.NET, etc).
Can anyone help me on how should i do the configuration.
Appreciate ur help.
Tks
Message posted via http://www.sqlmonster.com
Hi
http://www.microsoft.com/windowsserv...g/default.mspx
Importantly, the applications you install must be at least cluster aware.
http://msdn.microsoft.com/library/de...plications.asp
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mohd via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in message
news:a65b8f99202043dfba56c3b4499fb5a6@.SQLMonster.c om...
> Hi all,
> I'm new to clustering. Is there any website on how i could learn to
> configure clustering.
> I have 2 new servers(Svr1 & Svr2) and san storage. On Svr1 i'm going to
> install Win 2003 and sql 2000. Svr2 is going to be application server(dfs,
> VB.NET, etc).
> Can anyone help me on how should i do the configuration.
> Appreciate ur help.
> Tks
> --
> Message posted via http://www.sqlmonster.com
|||We website has a ton of information.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
"Mohd via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in message
news:a65b8f99202043dfba56c3b4499fb5a6@.SQLMonster.c om...
> Hi all,
> I'm new to clustering. Is there any website on how i could learn to
> configure clustering.
> I have 2 new servers(Svr1 & Svr2) and san storage. On Svr1 i'm going to
> install Win 2003 and sql 2000. Svr2 is going to be application server(dfs,
> VB.NET, etc).
> Can anyone help me on how should i do the configuration.
> Appreciate ur help.
> Tks
> --
> Message posted via http://www.sqlmonster.com
|||We? Where did that come from. I meant my. DOH!
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:OjlOfTDQFHA.204@.TK2MSFTNGP15.phx.gbl...
> We website has a ton of information.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> "Mohd via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in message
> news:a65b8f99202043dfba56c3b4499fb5a6@.SQLMonster.c om...
>

Clustered Index or NonClustered Index

Hello I want to learn disparity clustered index or nonclustered index and in queries which one run better.

example

select * from orders where orderID=5

to this query clustered or nonclustered

thanks

Big topic. Simple answer, yes, you probably want to cluster on the surrogate key, especially when using a smaller datatype surrogate like an int. The way SQL Server uses clustered indexes it is almost always the best choice.

Better answer. Read indexing topics in books online, and the start here one the web: http://www.sql-server-performance.com/optimizing_indexes.asp. Or just start there if you wanna. Books online has good information that is crucial to understanding indexes, however.

|||

Thank you very much