Need suggestion for SQL 2000

Hi,
I am researching about best practice for SQL load balance.
can someone suggest if there's article out there would expalin in details
doing the SQL 2000 load balcance.
I am planning the future failover so it does not impact users
any suggestions would appreciateIf your system is read / write there really is no easy way to load balance
SQL Server. Load balancing, HA and DR are different things and you need to
be clear on what it is you want or need to do.
--
Andrew J. Kelly SQL MVP
"Pooja" <Pooja@.discussions.microsoft.com> wrote in message
news:2B38DF31-D847-4193-A761-2125AFD7AE6D@.microsoft.com...
> Hi,
> I am researching about best practice for SQL load balance.
> can someone suggest if there's article out there would expalin in details
> doing the SQL 2000 load balcance.
> I am planning the future failover so it does not impact users
> any suggestions would appreciate
>|||HI,
My application reads/ writes to my sql server. Actaully, i am looking for
a plan where in future to create a disaster recovery plan. as of now I can't
keep my sql server down and I would like to create plan where I can create 2
server, load sql 2000..and if one fails, other will function.
I am looking for a suggestion what would be better solution if I should use
SQL locad balance, cluster, or mirror my harddrive..
since the application will update my db, so i need to have both sql server
data shoud be same.. can someone suggests me if there is a article I can find
in doing this...
would appreciate someone help..
"Andrew J. Kelly" wrote:
> If your system is read / write there really is no easy way to load balance
> SQL Server. Load balancing, HA and DR are different things and you need to
> be clear on what it is you want or need to do.
> --
> Andrew J. Kelly SQL MVP
>
> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
> news:2B38DF31-D847-4193-A761-2125AFD7AE6D@.microsoft.com...
> > Hi,
> >
> > I am researching about best practice for SQL load balance.
> > can someone suggest if there's article out there would expalin in details
> > doing the SQL 2000 load balcance.
> >
> > I am planning the future failover so it does not impact users
> > any suggestions would appreciate
> >
> >
>
>|||That is usually what a CLUSTER is for. It is a hardware failover solution
in the event one server fails the shared db is moved over to the other
server and can be up and running in les than a few minutes. Another
solution is to use Log Shipping. All are outlined here:
http://www.microsoft.com/sql/techinfo/administration/2000/availability.mspx
--
Andrew J. Kelly SQL MVP
"Pooja" <Pooja@.discussions.microsoft.com> wrote in message
news:AA498550-7F88-4E80-9800-CC0BEA00914E@.microsoft.com...
> HI,
> My application reads/ writes to my sql server. Actaully, i am looking for
> a plan where in future to create a disaster recovery plan. as of now I
> can't
> keep my sql server down and I would like to create plan where I can create
> 2
> server, load sql 2000..and if one fails, other will function.
> I am looking for a suggestion what would be better solution if I should
> use
> SQL locad balance, cluster, or mirror my harddrive..
> since the application will update my db, so i need to have both sql server
> data shoud be same.. can someone suggests me if there is a article I can
> find
> in doing this...
> would appreciate someone help..
> "Andrew J. Kelly" wrote:
>> If your system is read / write there really is no easy way to load
>> balance
>> SQL Server. Load balancing, HA and DR are different things and you need
>> to
>> be clear on what it is you want or need to do.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
>> news:2B38DF31-D847-4193-A761-2125AFD7AE6D@.microsoft.com...
>> > Hi,
>> >
>> > I am researching about best practice for SQL load balance.
>> > can someone suggest if there's article out there would expalin in
>> > details
>> > doing the SQL 2000 load balcance.
>> >
>> > I am planning the future failover so it does not impact users
>> > any suggestions would appreciate
>> >
>> >
>>|||Thanks Andrew,
I am researching on clustering the sql server. I will be using Vmware
product to test the cluster enviornment. I have one more questions, The
clustering the sql server stays stable in enviornment. does it have any pros
or cons by doin in cluster enviornment
"Andrew J. Kelly" wrote:
> That is usually what a CLUSTER is for. It is a hardware failover solution
> in the event one server fails the shared db is moved over to the other
> server and can be up and running in les than a few minutes. Another
> solution is to use Log Shipping. All are outlined here:
> http://www.microsoft.com/sql/techinfo/administration/2000/availability.mspx
> --
> Andrew J. Kelly SQL MVP
>
> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
> news:AA498550-7F88-4E80-9800-CC0BEA00914E@.microsoft.com...
> > HI,
> > My application reads/ writes to my sql server. Actaully, i am looking for
> > a plan where in future to create a disaster recovery plan. as of now I
> > can't
> > keep my sql server down and I would like to create plan where I can create
> > 2
> > server, load sql 2000..and if one fails, other will function.
> > I am looking for a suggestion what would be better solution if I should
> > use
> > SQL locad balance, cluster, or mirror my harddrive..
> > since the application will update my db, so i need to have both sql server
> > data shoud be same.. can someone suggests me if there is a article I can
> > find
> > in doing this...
> > would appreciate someone help..
> >
> > "Andrew J. Kelly" wrote:
> >
> >> If your system is read / write there really is no easy way to load
> >> balance
> >> SQL Server. Load balancing, HA and DR are different things and you need
> >> to
> >> be clear on what it is you want or need to do.
> >>
> >> --
> >> Andrew J. Kelly SQL MVP
> >>
> >>
> >> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
> >> news:2B38DF31-D847-4193-A761-2125AFD7AE6D@.microsoft.com...
> >> > Hi,
> >> >
> >> > I am researching about best practice for SQL load balance.
> >> > can someone suggest if there's article out there would expalin in
> >> > details
> >> > doing the SQL 2000 load balcance.
> >> >
> >> > I am planning the future failover so it does not impact users
> >> > any suggestions would appreciate
> >> >
> >> >
> >>
> >>
> >>
>
>|||If you are asking if testing in VMWARE is a good test for the real thing I
can't say. But I would not want to base my decision on such a test. One of
the most important things in considering a cluster is to make sure all your
hardware, OS etc. is on the Hardware Compatibility List for Clustering
(HCLC). If not then you are at risk of the cluster not working properly.
--
Andrew J. Kelly SQL MVP
"Pooja" <Pooja@.discussions.microsoft.com> wrote in message
news:138B7723-52D9-487B-BBD3-FCBC54407F1C@.microsoft.com...
> Thanks Andrew,
> I am researching on clustering the sql server. I will be using Vmware
> product to test the cluster enviornment. I have one more questions, The
> clustering the sql server stays stable in enviornment. does it have any
> pros
> or cons by doin in cluster enviornment
>
> "Andrew J. Kelly" wrote:
>> That is usually what a CLUSTER is for. It is a hardware failover
>> solution
>> in the event one server fails the shared db is moved over to the other
>> server and can be up and running in les than a few minutes. Another
>> solution is to use Log Shipping. All are outlined here:
>> http://www.microsoft.com/sql/techinfo/administration/2000/availability.mspx
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
>> news:AA498550-7F88-4E80-9800-CC0BEA00914E@.microsoft.com...
>> > HI,
>> > My application reads/ writes to my sql server. Actaully, i am looking
>> > for
>> > a plan where in future to create a disaster recovery plan. as of now I
>> > can't
>> > keep my sql server down and I would like to create plan where I can
>> > create
>> > 2
>> > server, load sql 2000..and if one fails, other will function.
>> > I am looking for a suggestion what would be better solution if I should
>> > use
>> > SQL locad balance, cluster, or mirror my harddrive..
>> > since the application will update my db, so i need to have both sql
>> > server
>> > data shoud be same.. can someone suggests me if there is a article I
>> > can
>> > find
>> > in doing this...
>> > would appreciate someone help..
>> >
>> > "Andrew J. Kelly" wrote:
>> >
>> >> If your system is read / write there really is no easy way to load
>> >> balance
>> >> SQL Server. Load balancing, HA and DR are different things and you
>> >> need
>> >> to
>> >> be clear on what it is you want or need to do.
>> >>
>> >> --
>> >> Andrew J. Kelly SQL MVP
>> >>
>> >>
>> >> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
>> >> news:2B38DF31-D847-4193-A761-2125AFD7AE6D@.microsoft.com...
>> >> > Hi,
>> >> >
>> >> > I am researching about best practice for SQL load balance.
>> >> > can someone suggest if there's article out there would expalin in
>> >> > details
>> >> > doing the SQL 2000 load balcance.
>> >> >
>> >> > I am planning the future failover so it does not impact users
>> >> > any suggestions would appreciate
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>

Need suggestion for SQL 2000

Hi,
I am researching about best practice for SQL load balance.
can someone suggest if there's article out there would expalin in details
doing the SQL 2000 load balcance.
I am planning the future failover so it does not impact users
any suggestions would appreciateIf your system is read / write there really is no easy way to load balance
SQL Server. Load balancing, HA and DR are different things and you need to
be clear on what it is you want or need to do.
Andrew J. Kelly SQL MVP
"Pooja" <Pooja@.discussions.microsoft.com> wrote in message
news:2B38DF31-D847-4193-A761-2125AFD7AE6D@.microsoft.com...
> Hi,
> I am researching about best practice for SQL load balance.
> can someone suggest if there's article out there would expalin in details
> doing the SQL 2000 load balcance.
> I am planning the future failover so it does not impact users
> any suggestions would appreciate
>|||HI,
My application reads/ writes to my sql server. Actaully, i am looking for
a plan where in future to create a disaster recovery plan. as of now I can't
keep my sql server down and I would like to create plan where I can create 2
server, load sql 2000..and if one fails, other will function.
I am looking for a suggestion what would be better solution if I should use
SQL locad balance, cluster, or mirror my harddrive..
since the application will update my db, so i need to have both sql server
data shoud be same.. can someone suggests me if there is a article I can fin
d
in doing this...
would appreciate someone help..
"Andrew J. Kelly" wrote:

> If your system is read / write there really is no easy way to load balance
> SQL Server. Load balancing, HA and DR are different things and you need t
o
> be clear on what it is you want or need to do.
> --
> Andrew J. Kelly SQL MVP
>
> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
> news:2B38DF31-D847-4193-A761-2125AFD7AE6D@.microsoft.com...
>
>|||That is usually what a CLUSTER is for. It is a hardware failover solution
in the event one server fails the shared db is moved over to the other
server and can be up and running in les than a few minutes. Another
solution is to use Log Shipping. All are outlined here:
http://www.microsoft.com/sql/techin...ailability.mspx
Andrew J. Kelly SQL MVP
"Pooja" <Pooja@.discussions.microsoft.com> wrote in message
news:AA498550-7F88-4E80-9800-CC0BEA00914E@.microsoft.com...[vbcol=seagreen]
> HI,
> My application reads/ writes to my sql server. Actaully, i am looking for
> a plan where in future to create a disaster recovery plan. as of now I
> can't
> keep my sql server down and I would like to create plan where I can create
> 2
> server, load sql 2000..and if one fails, other will function.
> I am looking for a suggestion what would be better solution if I should
> use
> SQL locad balance, cluster, or mirror my harddrive..
> since the application will update my db, so i need to have both sql server
> data shoud be same.. can someone suggests me if there is a article I can
> find
> in doing this...
> would appreciate someone help..
> "Andrew J. Kelly" wrote:
>|||Thanks Andrew,
I am researching on clustering the sql server. I will be using Vmware
product to test the cluster enviornment. I have one more questions, The
clustering the sql server stays stable in enviornment. does it have any pros
or cons by doin in cluster enviornment
"Andrew J. Kelly" wrote:

> That is usually what a CLUSTER is for. It is a hardware failover solution
> in the event one server fails the shared db is moved over to the other
> server and can be up and running in les than a few minutes. Another
> solution is to use Log Shipping. All are outlined here:
> [url]http://www.microsoft.com/sql/techinfo/administration/2000/availability.mspx[/url
]
> --
> Andrew J. Kelly SQL MVP
>
> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
> news:AA498550-7F88-4E80-9800-CC0BEA00914E@.microsoft.com...
>
>|||If you are asking if testing in VMWARE is a good test for the real thing I
can't say. But I would not want to base my decision on such a test. One of
the most important things in considering a cluster is to make sure all your
hardware, OS etc. is on the hardware Compatibility List for Clustering
(HCLC). If not then you are at risk of the cluster not working properly.
Andrew J. Kelly SQL MVP
"Pooja" <Pooja@.discussions.microsoft.com> wrote in message
news:138B7723-52D9-487B-BBD3-FCBC54407F1C@.microsoft.com...[vbcol=seagreen]
> Thanks Andrew,
> I am researching on clustering the sql server. I will be using Vmware
> product to test the cluster enviornment. I have one more questions, The
> clustering the sql server stays stable in enviornment. does it have any
> pros
> or cons by doin in cluster enviornment
>
> "Andrew J. Kelly" wrote:
>

Need suggestion for SQL 2000

Hi,
I am researching about best practice for SQL load balance.
can someone suggest if there's article out there would expalin in details
doing the SQL 2000 load balcance.
I am planning the future failover so it does not impact users
any suggestions would appreciate
If your system is read / write there really is no easy way to load balance
SQL Server. Load balancing, HA and DR are different things and you need to
be clear on what it is you want or need to do.
Andrew J. Kelly SQL MVP
"Pooja" <Pooja@.discussions.microsoft.com> wrote in message
news:2B38DF31-D847-4193-A761-2125AFD7AE6D@.microsoft.com...
> Hi,
> I am researching about best practice for SQL load balance.
> can someone suggest if there's article out there would expalin in details
> doing the SQL 2000 load balcance.
> I am planning the future failover so it does not impact users
> any suggestions would appreciate
>
|||HI,
My application reads/ writes to my sql server. Actaully, i am looking for
a plan where in future to create a disaster recovery plan. as of now I can't
keep my sql server down and I would like to create plan where I can create 2
server, load sql 2000..and if one fails, other will function.
I am looking for a suggestion what would be better solution if I should use
SQL locad balance, cluster, or mirror my harddrive..
since the application will update my db, so i need to have both sql server
data shoud be same.. can someone suggests me if there is a article I can find
in doing this...
would appreciate someone help..
"Andrew J. Kelly" wrote:

> If your system is read / write there really is no easy way to load balance
> SQL Server. Load balancing, HA and DR are different things and you need to
> be clear on what it is you want or need to do.
> --
> Andrew J. Kelly SQL MVP
>
> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
> news:2B38DF31-D847-4193-A761-2125AFD7AE6D@.microsoft.com...
>
>
|||That is usually what a CLUSTER is for. It is a hardware failover solution
in the event one server fails the shared db is moved over to the other
server and can be up and running in les than a few minutes. Another
solution is to use Log Shipping. All are outlined here:
http://www.microsoft.com/sql/techinf...ilability.mspx
Andrew J. Kelly SQL MVP
"Pooja" <Pooja@.discussions.microsoft.com> wrote in message
news:AA498550-7F88-4E80-9800-CC0BEA00914E@.microsoft.com...[vbcol=seagreen]
> HI,
> My application reads/ writes to my sql server. Actaully, i am looking for
> a plan where in future to create a disaster recovery plan. as of now I
> can't
> keep my sql server down and I would like to create plan where I can create
> 2
> server, load sql 2000..and if one fails, other will function.
> I am looking for a suggestion what would be better solution if I should
> use
> SQL locad balance, cluster, or mirror my harddrive..
> since the application will update my db, so i need to have both sql server
> data shoud be same.. can someone suggests me if there is a article I can
> find
> in doing this...
> would appreciate someone help..
> "Andrew J. Kelly" wrote:
|||Thanks Andrew,
I am researching on clustering the sql server. I will be using Vmware
product to test the cluster enviornment. I have one more questions, The
clustering the sql server stays stable in enviornment. does it have any pros
or cons by doin in cluster enviornment
"Andrew J. Kelly" wrote:

> That is usually what a CLUSTER is for. It is a hardware failover solution
> in the event one server fails the shared db is moved over to the other
> server and can be up and running in les than a few minutes. Another
> solution is to use Log Shipping. All are outlined here:
> http://www.microsoft.com/sql/techinf...ilability.mspx
> --
> Andrew J. Kelly SQL MVP
>
> "Pooja" <Pooja@.discussions.microsoft.com> wrote in message
> news:AA498550-7F88-4E80-9800-CC0BEA00914E@.microsoft.com...
>
>
|||If you are asking if testing in VMWARE is a good test for the real thing I
can't say. But I would not want to base my decision on such a test. One of
the most important things in considering a cluster is to make sure all your
hardware, OS etc. is on the Hardware Compatibility List for Clustering
(HCLC). If not then you are at risk of the cluster not working properly.
Andrew J. Kelly SQL MVP
"Pooja" <Pooja@.discussions.microsoft.com> wrote in message
news:138B7723-52D9-487B-BBD3-FCBC54407F1C@.microsoft.com...[vbcol=seagreen]
> Thanks Andrew,
> I am researching on clustering the sql server. I will be using Vmware
> product to test the cluster enviornment. I have one more questions, The
> clustering the sql server stays stable in enviornment. does it have any
> pros
> or cons by doin in cluster enviornment
>
> "Andrew J. Kelly" wrote:
sql

Need some practice

Please point me to a web resource from where I can study:

1) writing complex queries such as those involving HAVING, mult-level
nested queries, GROUP BY, T-SQL functions

2) Joins - a lot of practice

3) Stored Procedures, transactions, cursors and triggers - I need some
heavy-duty practice

Where can I get some good practice of the above? Also, please recommend
a good SQL Server/T-SQL book in the light of the above requirement.Here's a good one for joins. I like the colors for the join tables:

http://www.tek-tips.com/faqs.cfm?fid=4785|||Have you gotten a copy of SQL FOR SMARTIES yet? It is required for
working SQL programmers. And my house payment :)|||> Have you gotten a copy of SQL FOR SMARTIES yet? It is required for
> working SQL programmers. And my house payment :)

The book is of little use to working SQL programmers, a lot of the examples
aren't directly useable in SQL Server nor do they scale into the real world.

People are better off spending a couple of minutes searching GOOGLE for the
answers.

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials

"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1144801857.130733.158410@.i40g2000cwc.googlegr oups.com...
> Have you gotten a copy of SQL FOR SMARTIES yet? It is required for
> working SQL programmers. And my house payment :)

Need some practice

Please point me to a web resource from where I can study:
1) writing complex queries such as those involving HAVING, mult-level
nested queries, GROUP BY, T-SQL functions
2) Joins - a lot of practice
3) Stored Procedures, transactions, cursors and triggers - I need some
heavy-duty practice
Where can I get some good practice of the above? Also, please recommend
a good SQL Server/T-SQL book in the light of the above requirement.Some basic sites that have a couple examples...
http://www.w3schools.com/sql/sql_intro.asp
http://sqlzoo.net/
http://www.geocities.com/SiliconVal.../2207/sql1.html
If you want more comlicated examples, this forum may be the most useful.
You will have to sort through a lot of different posts that do not have what
you are looking for, but you will find dozens of solutions to various
problems that you can learn from.
"Water Cooler v2" <wtr_clr@.yahoo.com> wrote in message
news:1144682834.749751.324310@.i39g2000cwa.googlegroups.com...
> Please point me to a web resource from where I can study:
> 1) writing complex queries such as those involving HAVING, mult-level
> nested queries, GROUP BY, T-SQL functions
> 2) Joins - a lot of practice
> 3) Stored Procedures, transactions, cursors and triggers - I need some
> heavy-duty practice
>
> Where can I get some good practice of the above? Also, please recommend
> a good SQL Server/T-SQL book in the light of the above requirement.
>|||Here's a good one for joins. I like the colors for the join tables:
http://www.tek-tips.com/faqs.cfm?fid=4785|||Have you gotten a copy of SQL FOR SMARTIES yet? It is required for
working SQL programmers. And my house payment :)|||> Have you gotten a copy of SQL FOR SMARTIES yet? It is required for
> working SQL programmers. And my house payment :)
The book is of little use to working SQL programmers, a lot of the examples
aren't directly useable in SQL Server nor do they scale into the real world.
People are better off spending a couple of minutes searching GOOGLE for the
answers.
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1144801857.130733.158410@.i40g2000cwc.googlegroups.com...
> Have you gotten a copy of SQL FOR SMARTIES yet? It is required for
> working SQL programmers. And my house payment :)
>

need sample code in c# to connect to sql database

hi,
i learn by practice and i would like an asp code using c# that connects to sql database can retrives information from a table.
can you please copy paste me some code or give me exact link a?

thank youHere is a tutorial.