getting started 101

hello,

i own about a dozen interactive forums (see example at http://ConcealedCarryForum.com for one of them) that i host on a windows 2000 server dedicated server out of my home on a commercial cable backbone. the forums are ASP using Access DBs. we have outgrown the capabilities of Access and are getting complaints from DB lag during peak usage, and i must upgrade my DB to ensure the QOS end users get from my forums. i have no intention of switching over to php/MySQL/linux formats.

i tried unsuccessfully to get MySQL to play nicely in a windows environment, and recently learned that MSSQL offers free versions, the compact and the express. trouble is, i know absolutely nothing about DB management. Access is idiot proof so i have used it as long as i could. now i find myself in a scramble to learn how to create, employ, and use a more powerful DB.

for my intended usage (running about a dozen DBs on a dedicated server), will compact or express be the appropriate version to start learning? for my intended usage, is there any benefit to downloading/installing/learning the additional tools that are also available? if so, which tools? where do i learn how to create new DBs, and what tools do i need to do this? most tech papers ive seen on MSSQL assume a prior working knowledge of MSSQL DB management and im coming into this completely ignorant but willing to dedicate myself to learning.

answers, advice, etc. very much appreciated.

SQL Server Express should be your best pick (if the volume of the database increases you can easily update to any non-free version of SQL Server). SQL Server Compact edition is a inproc running database which does no need to be installed on the Server. SQL Server Express uses a Service running on the database server, if you are able to install services or use existing on your web server this option should be fine for you. SQL Express is not harder to learn than Access, see the following liknk to get an impression of the features and to get your feet wet:

http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

thank you, this is exactly what i was looking for. any idea how many simultaneous connections MSSQL express can handle? i know Access handles 20.

thanks again,

|||

There is no technical limit to the number of connection that SQL Express can handle. SQL Express has the following limitations:

1 GB of memory

1 Processor socket

4 GB of user data per database

getting started 101

hello,

i own about a dozen interactive forums (see example at http://ConcealedCarryForum.com for one of them) that i host on a windows 2000 server dedicated server out of my home on a commercial cable backbone. the forums are ASP using Access DBs. we have outgrown the capabilities of Access and are getting complaints from DB lag during peak usage, and i must upgrade my DB to ensure the QOS end users get from my forums. i have no intention of switching over to php/MySQL/linux formats.

i tried unsuccessfully to get MySQL to play nicely in a windows environment, and recently learned that MSSQL offers free versions, the compact and the express. trouble is, i know absolutely nothing about DB management. Access is idiot proof so i have used it as long as i could. now i find myself in a scramble to learn how to create, employ, and use a more powerful DB.

for my intended usage (running about a dozen DBs on a dedicated server), will compact or express be the appropriate version to start learning? for my intended usage, is there any benefit to downloading/installing/learning the additional tools that are also available? if so, which tools? where do i learn how to create new DBs, and what tools do i need to do this? most tech papers ive seen on MSSQL assume a prior working knowledge of MSSQL DB management and im coming into this completely ignorant but willing to dedicate myself to learning.

answers, advice, etc. very much appreciated.

SQL Server Express should be your best pick (if the volume of the database increases you can easily update to any non-free version of SQL Server). SQL Server Compact edition is a inproc running database which does no need to be installed on the Server. SQL Server Express uses a Service running on the database server, if you are able to install services or use existing on your web server this option should be fine for you. SQL Express is not harder to learn than Access, see the following liknk to get an impression of the features and to get your feet wet:

http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

thank you, this is exactly what i was looking for. any idea how many simultaneous connections MSSQL express can handle? i know Access handles 20.

thanks again,

|||

There is no technical limit to the number of connection that SQL Express can handle. SQL Express has the following limitations:

1 GB of memory

1 Processor socket

4 GB of user data per database

Getting rid of DOUBLE SPACING!

I just took over admin control of a website at http://www.lyricster.com and
I am having a hell of a time trying to pin down the problem of double
spacing when I add new lyrics to the database.

The thing is, most all of the db items (lyrics) on the website are single
spaced, and yet when I try to post new lyrics, it comes out double-spaced.
I even tried to log in as a normal user and post lyrics that way...same
problem.

If you need example of the problem go to the site, click on "Runnin' With
The Devil - Van Halen" and then click on a few other of the song
titles...all of the ones that have double spaced text are mine.

HELP!!!!I should add that the double spacing problem is not on the input side, but
how the database info is parsed out to the screen. Hope this clears it up
a bit more.

"Moviesounds.com" <aarrowstar@.yahoo.com> wrote in message
news:oy8Mb.13906$6y6.377982@.bgtnsc05-news.ops.worldnet.att.net...
> I just took over admin control of a website at http://www.lyricster.com
and
> I am having a hell of a time trying to pin down the problem of double
> spacing when I add new lyrics to the database.
> The thing is, most all of the db items (lyrics) on the website are single
> spaced, and yet when I try to post new lyrics, it comes out double-spaced.
> I even tried to log in as a normal user and post lyrics that way...same
> problem.
> If you need example of the problem go to the site, click on "Runnin' With
> The Devil - Van Halen" and then click on a few other of the song
> titles...all of the ones that have double spaced text are mine.
> HELP!!!!|||Moviesounds.com (aarrowstar@.yahoo.com) writes:
> I just took over admin control of a website at http://www.lyricster.com
> and I am having a hell of a time trying to pin down the problem of
> double spacing when I add new lyrics to the database.
> The thing is, most all of the db items (lyrics) on the website are single
> spaced, and yet when I try to post new lyrics, it comes out double-spaced.
> I even tried to log in as a normal user and post lyrics that way...same
> problem.
> If you need example of the problem go to the site, click on "Runnin' With
> The Devil - Van Halen" and then click on a few other of the song
> titles...all of the ones that have double spaced text are mine.

The HTML for the Van Halen thing looks like this:

So tell me why can't this be love <br />
<BR><br />
Straight from my heart oh tell me why <br />
<BR><br /
The extra <BR><br /> explains the double spacing. But neither the
single-spaced are OK:

you\'re always there <br />
<br />
\'Cause you\'re everywhere to me <br />
And when I close my eyes it\'s you I see <br /
What is that backslash doing before the single quotes?

Now, if you believe that this is a problem with SQL Server, then you
really have to provide your information. When you perform a SELECT
on the tables from Query Analyzer what do you see?

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns946DA89388BC0Yazorman@.127.0.0.1...
> Moviesounds.com (aarrowstar@.yahoo.com) writes:
> > I just took over admin control of a website at http://www.lyricster.com
> > and I am having a hell of a time trying to pin down the problem of
> > double spacing when I add new lyrics to the database.
> > The thing is, most all of the db items (lyrics) on the website are
single
> > spaced, and yet when I try to post new lyrics, it comes out
double-spaced.
> > I even tried to log in as a normal user and post lyrics that way...same
> > problem.
> > If you need example of the problem go to the site, click on "Runnin'
With
> > The Devil - Van Halen" and then click on a few other of the song
> > titles...all of the ones that have double spaced text are mine.
> The HTML for the Van Halen thing looks like this:
> So tell me why can't this be love <br />
> <BR><br />
> Straight from my heart oh tell me why <br />
> <BR><br />
> The extra <BR><br /> explains the double spacing. But neither the
> single-spaced are OK:
> you\'re always there <br />
> <br />
> \'Cause you\'re everywhere to me <br />
> And when I close my eyes it\'s you I see <br />
> What is that backslash doing before the single quotes?
> Now, if you believe that this is a problem with SQL Server, then you
> really have to provide your information. When you perform a SELECT
> on the tables from Query Analyzer what do you see?
>
No idea, dude...I'm just a hack trying to figure out why the single-spaced
text I'm inputting into the myPHPserver interface with the SQL server is
parsing out as double spaced text when the request is made for a database
item.

In other words, I have no idea what a query analyzer is or where I could
find it. The myPHP documentation is definitely written for those already in
the know.

Also, I am not inputting any markup tags on the text...the server is doing
that on it's own.|||Moviesounds.com (aarrowstar@.yahoo.com) writes:
> No idea, dude...I'm just a hack trying to figure out why the
> single-spaced text I'm inputting into the myPHPserver interface with the
> SQL server is parsing out as double spaced text when the request is made
> for a database item.
> In other words, I have no idea what a query analyzer is or where I could
> find it. The myPHP documentation is definitely written for those
> already in the know.

Query Analyzer is a tool that comes with SQL Server, unless you only have
MSDE, in which case it is not included. I believe that with MSDE you may
still have OSQL, a command-line tool with which you can submit queries.

PHP I don't know anything about.

> Also, I am not inputting any markup tags on the text...the server is
> doing that on it's own.

Maybe the myPHPserver thing does. SQL Server does not, unless they are
part of the queries.

I'm afraid that you will not get much help here. If you don't know what
your system is doing, don't exepect people who don't have access to it
to find out.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"Moviesounds.com" <aarrowstar@.yahoo.com> wrote in message news:<GrmMb.4866$VS4.160767@.bgtnsc04-news.ops.worldnet.att.net>...
> "Erland Sommarskog" <sommar@.algonet.se> wrote in message
> news:Xns946DA89388BC0Yazorman@.127.0.0.1...
> > Moviesounds.com (aarrowstar@.yahoo.com) writes:
> > > I just took over admin control of a website at http://www.lyricster.com
> > > and I am having a hell of a time trying to pin down the problem of
> > > double spacing when I add new lyrics to the database.
> > > > The thing is, most all of the db items (lyrics) on the website are
> single
> > > spaced, and yet when I try to post new lyrics, it comes out
> double-spaced.
> > > I even tried to log in as a normal user and post lyrics that way...same
> > > problem.
> > > > If you need example of the problem go to the site, click on "Runnin'
> With
> > > The Devil - Van Halen" and then click on a few other of the song
> > > titles...all of the ones that have double spaced text are mine.
> > The HTML for the Van Halen thing looks like this:
> > So tell me why can't this be love <br />
> > <BR><br />
> > Straight from my heart oh tell me why <br />
> > <BR><br />
> > The extra <BR><br /> explains the double spacing. But neither the
> > single-spaced are OK:
> > you\'re always there <br />
> > <br />
> > \'Cause you\'re everywhere to me <br />
> > And when I close my eyes it\'s you I see <br />
> > What is that backslash doing before the single quotes?
> > Now, if you believe that this is a problem with SQL Server, then you
> > really have to provide your information. When you perform a SELECT
> > on the tables from Query Analyzer what do you see?
> No idea, dude...I'm just a hack trying to figure out why the single-spaced
> text I'm inputting into the myPHPserver interface with the SQL server is
> parsing out as double spaced text when the request is made for a database
> item.
> In other words, I have no idea what a query analyzer is or where I could
> find it. The myPHP documentation is definitely written for those already in
> the know.
> Also, I am not inputting any markup tags on the text...the server is doing
> that on it's own.

I believe that MyPHP is used to link PHP to MySQL, not to MSSQL
(Microsoft SQL Server). So you will probably get a better response in
a newsgroup for MySQL and/or PHP than for MSSQL.

If I had to guess (and I do, since I know nothing about PHP or MySQL),
I would say that the problem is more likely to be in the PHP code, not
in the database.

Simon