Installing SQL Server Express?

Hi,
I'm using Win SBS 2003 with SQL Server 2000 as our main database centre.
Recently when I tried to install aplication that's using SQL Server 2000
(written in C#) in computer workstations, I recognized that it take too long
of time to load those databases in server.
Perhaps I need SQL Server Express in each computer workstations, so it can
run faster?
Thanks!Hi
Are you planning to upgrade to SQL Server 2005? In terms of perfomance you
would want to test the server before starting to use. I have seen about 20
percent improvments in SQL Server 2005 when we tested it , however it
depends on lots of parameters and you need to test it on your enviroment

>I recognized that it take too long
> of time to load those databases in server.
What , to install SQL Serrver 2000?
"Dhow" <Dhow@.discussions.microsoft.com> wrote in message
news:FA808838-5DF5-49D4-AF5F-E175BF8868C3@.microsoft.com...
> Hi,
> I'm using Win SBS 2003 with SQL Server 2000 as our main database centre.
> Recently when I tried to install aplication that's using SQL Server 2000
> (written in C#) in computer workstations, I recognized that it take too
> long
> of time to load those databases in server.
> Perhaps I need SQL Server Express in each computer workstations, so it can
> run faster?
> Thanks!|||Hi Uri,
No, I'm not planning to upgrade to SQL Server 2005.
What I'm trying to do is install a mini-SQL Server Client in each computer
workstations; and hoping that the application that uses SQL Server 2000
database can load it (the database) faster.
Can this be done?
Thank you.
"Uri Dimant" wrote:

> Hi
> Are you planning to upgrade to SQL Server 2005? In terms of perfomance yo
u
> would want to test the server before starting to use. I have seen about 20
> percent improvments in SQL Server 2005 when we tested it , however it
> depends on lots of parameters and you need to test it on your enviroment
>
> What , to install SQL Serrver 2000?
>
>
> "Dhow" <Dhow@.discussions.microsoft.com> wrote in message
> news:FA808838-5DF5-49D4-AF5F-E175BF8868C3@.microsoft.com...
>
>|||Hi

>Perhaps I need SQL Server Express in each computer >workstations, so it can
>run faster?
Does not SQL Server Express Edition belong to SQL Server 2005 MS Product?
Yes, you can install SQL Server Express on all workstations so prior just
restore a SQL Server 2000 database to SQL Server Express edition, be aware
it is limited to 4GB database size
"Dhow" <Dhow@.discussions.microsoft.com> wrote in message
news:AFF6AAC5-6683-4DAA-B9F0-250197D676DF@.microsoft.com...[vbcol=seagreen]
> Hi Uri,
> No, I'm not planning to upgrade to SQL Server 2005.
> What I'm trying to do is install a mini-SQL Server Client in each computer
> workstations; and hoping that the application that uses SQL Server 2000
> database can load it (the database) faster.
> Can this be done?
> Thank you.
> "Uri Dimant" wrote:
>|||Do you know why the application is slow? Although creating a local copy of
database might help performance somewhat, that won't address the root cause
that needs to be addressed.
Hope this helps.
Dan Guzman
SQL Server MVP
"Dhow" <Dhow@.discussions.microsoft.com> wrote in message
news:AFF6AAC5-6683-4DAA-B9F0-250197D676DF@.microsoft.com...[vbcol=seagreen]
> Hi Uri,
> No, I'm not planning to upgrade to SQL Server 2005.
> What I'm trying to do is install a mini-SQL Server Client in each computer
> workstations; and hoping that the application that uses SQL Server 2000
> database can load it (the database) faster.
> Can this be done?
> Thank you.
> "Uri Dimant" wrote:
>|||Hi Dan,
My bet is that this application takes up too much long time to load the
pictures database (they're in *.jpg files), along with the items' details.
The application is written in C#, and access the SQL Server 2000 database in
the server through wireless LAN. That's why I thought it'll fasten the uploa
d
data if I installed SQL Server Express in every workstations computer that
access the database in the server.
And I know nothing about the application programming, shoud the programmer
add some command line in the application to tell it to get the database? Or
it'll be simply automatically retrieve the database by itselves?
Thanks!
"Dan Guzman" wrote:

> Do you know why the application is slow? Although creating a local copy o
f
> database might help performance somewhat, that won't address the root caus
e
> that needs to be addressed.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Dhow" <Dhow@.discussions.microsoft.com> wrote in message
> news:AFF6AAC5-6683-4DAA-B9F0-250197D676DF@.microsoft.com...
>
>|||Hi Uri,
Yes, I know SQL Server Express is part of the SQL Server 2005, not the SQL
Server 2000 that I currently have. Still, can I intall and use it in each
workstation computers? Although it'll be accessing SQL Server 2000 in the
server.
Do I need to ask the programmer to put some sort like command line in the
application or in the SQL Server Express to retrieve the database? Or it'll
be automatically? I ask you this because I know nothing about SQL Server at
all.
Thank you.
"Uri Dimant" wrote:

> Hi
>
> Does not SQL Server Express Edition belong to SQL Server 2005 MS Product?
>
> Yes, you can install SQL Server Express on all workstations so prior just
> restore a SQL Server 2000 database to SQL Server Express edition, be aware
> it is limited to 4GB database size
>
>
>
> "Dhow" <Dhow@.discussions.microsoft.com> wrote in message
> news:AFF6AAC5-6683-4DAA-B9F0-250197D676DF@.microsoft.com...
>
>|||Why you need to install an SQL Server/SQL Server Express on each workstation
when the app is to access the data on the server SQL Server?
I can only imagine in a few cases where you may want to store data locally
(on the app running computer) and synchronize data back to the server in
someway. For example, if the computer does not connect to the server network
often, or the network does not fit such a traffic fo data volume. In this
case, you have to save the data locally as file or in a local database. And
then you would provide a way to synchronize data back to the server on the
network, in a suitable time window. That is added complexity to your app.
On the other hand, if the data (picture) must be shared among users
simultaneously, just as normal central database, the local database does not
help much, 'cause you have to synchronize local data to the server all the
time. As long as the network is allowed, the app would be better off
directly connect to the server.
Since your problem is "app is too low", adding a local database may or may
not solve your problem. You need to find out why it is low in that certain
network environment. In your other post, you mentioned that the app load
many pictures from the database, that could be the reason of slowness. IMO,
to install a SQL Server locally on each computer only helps when you do not
need to share those picture with other users concurrently (so you do not
have to update the changes (of the picutres) on the local database back to
server very often. Even so, it only improves the bottle neck of network
traffic. Retrieveing too many pictures from database is always a heavy
process. Chances are the app is still slow when retrieving too many picture
from local database. You may want to reconsider the app logic to retrieve
the picture(s) when it is really necessary, and retrieve it (then) as less
as possible.
"Dhow" <Dhow@.discussions.microsoft.com> wrote in message
news:FA808838-5DF5-49D4-AF5F-E175BF8868C3@.microsoft.com...
> Hi,
> I'm using Win SBS 2003 with SQL Server 2000 as our main database centre.
> Recently when I tried to install aplication that's using SQL Server 2000
> (written in C#) in computer workstations, I recognized that it take too
> long
> of time to load those databases in server.
> Perhaps I need SQL Server Express in each computer workstations, so it can
> run faster?
> Thanks!|||"Dhow" <Dhow@.discussions.microsoft.com> wrote in message
news:90002B0B-4E5D-4332-8550-F4C9096FBCBA@.microsoft.com...
> Hi Uri,
> Yes, I know SQL Server Express is part of the SQL Server 2005, not the SQL
> Server 2000 that I currently have. Still, can I intall and use it in each
> workstation computers? Although it'll be accessing SQL Server 2000 in the
> server.
I'm really not clear on what you're doing here.
Is the Database on a centralized SQL 2000 Server or does each client have a
copy?
You realize SQL 2000 and SQL 2005 are servers, not necessarily desktop
applications (though there are client applications that run on the desktop.)
So, I think you're either misunderstanding how SQL 2000/2005 would
interoperate, or you have a more advanced system (some sort of detached
client running repliction/synch) with a centralized server.

> Do I need to ask the programmer to put some sort like command line in the
> application or in the SQL Server Express to retrieve the database? Or
it'll
> be automatically? I ask you this because I know nothing about SQL Server
at[vbcol=seagreen]
> all.
> Thank you.
>
> "Uri Dimant" wrote:
>
can[vbcol=seagreen]
Product?[vbcol=seagreen]
just[vbcol=seagreen]
aware[vbcol=seagreen]
computer[vbcol=seagreen]
2000[vbcol=seagreen]
perfomance[vbcol=seagreen]
about[vbcol=seagreen]
it[vbcol=seagreen]
enviroment[vbcol=seagreen]
too[vbcol=seagreen]
it[vbcol=seagreen]|||Hi Greg,
I think Norman Yuan has answered your question to me there, just look under.
"Greg D. Moore (Strider)" wrote:

> "Dhow" <Dhow@.discussions.microsoft.com> wrote in message
> news:90002B0B-4E5D-4332-8550-F4C9096FBCBA@.microsoft.com...
> I'm really not clear on what you're doing here.
> Is the Database on a centralized SQL 2000 Server or does each client have
a
> copy?
> You realize SQL 2000 and SQL 2005 are servers, not necessarily desktop
> applications (though there are client applications that run on the desktop
.)
> So, I think you're either misunderstanding how SQL 2000/2005 would
> interoperate, or you have a more advanced system (some sort of detached
> client running repliction/synch) with a centralized server.
>
> it'll
> at
> can
> Product?
> just
> aware
> computer
> 2000
> perfomance
> about
> it
> enviroment
> too
> it
>
>sql