Re: MSDE Performance and Reliability

"Robert Baker" <zxytek@xxxxxxxxxxx> wrote in message
news:4672ac34@xxxxxxxxxxxxxxxxxxxxxxxxx
I have found it to be supurb. Unless the database is very
<good info snipped >

I uninstalled whatever version came with Visual Studio and installed the
latest SQL Express and the tools. So far, it looks pretty good. I have been
considering using it to awhile and learning more about SQL Server could
never hurt.

How large of an installation at a single site have you seen? I have a large
number of computers attached to a network, but access to my database is
actually quite dettached so there are few concurrent file accesses, and
those are short.

My database with all table will probably be up to 1.5 GB maximum.

If I have TCP/IP access open and whatever ports it uses, can I access the
database remotely over the internet with this version?

I look forward to learning some more about this product, so any good book
recommendations would help. I like to sit and turn pages and not read online
all the time.

Thanks a bunch!
Johnnie



.

Relevant Pages

  • RE: Installing SP4 on SQL 2000
    ... I have only recently re-installed SQL on my machine, ... As well as kb article 303747 "How to install SQL Server ... I notice on page 1 of the removal kb that it lists a set of database files ... uninstall, perhaps I should try that, with the installation disk, first? ...
    (microsoft.public.sqlserver.setup)
  • Cannot access Sql Db (Northwind) from Server Explorer in VB.NET
    ... During the installation it automatically ... I created a new windows program and opened up server explorer. ... Studio can only open Sql Desktop or Access databases. ... Lastly, in server explorer, if I right-click on create new database ...
    (microsoft.public.sqlserver.setup)
  • Re: MAJOR SQL and SharePoint Upgrade - Help with Installation Overview
    ... The version of SQL Server 2005 Express used with the Basic installation of WSS 3.0 ("Windows Internal Database") does not have any size limits. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Cannot save document. Form Validation Error..Web Server is busy
    ... It is observed that in Sharepoint Portal Server 2003, ... database is installed on a MSDE instance. ... Is there a way to convert/migrate/ that database instance to SQL ... assuming the installation directory of SQL server is on C ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Cant Install SP4 for SQL 2000 / Win2k3
    ... the installation hangs at "Validating User. ... > Database 'msdb' cannot be opened. ... > See the SQL Server errorlog for more information. ...
    (microsoft.public.sqlserver.setup)