Questions on SQL Server

[Accesshelp]

Hello all,

I am sure this place is a right place to ask questions on SQL Server.

I want to create a SQL Server, and I do not know how to get started. I have
tried 2003 SQL Server Express, and it did not work for me due to the limit of
database size at 4GB. I need a database with at least 100GB capacity.

My current plan is to buy a $500 desktop computer for the purpose of hosting
the SQL Server. I will have SQL Server as a back-end database and Access as
a front-end database. I also may want to access the SQL Server from Access
FE in a laptop computer.

If you can share with me how I can get started and how much it will cost me,
I would be greatly appreciated.

 

[Stefan Hoffmann]

hi,

I am sure this place is a right place to ask questions on SQL Server.

You should ask this question in one of the microsoft.public.sqlserver.*
groups.

I need a database with at least 100GB capacity.
My current plan is to buy a $500 desktop computer for the purpose of hosting
the SQL Server.

While such a computer can handle such a database, the question is 'How
will it perform?'. So what kind of database is it, how many concurrent
users do you have, how much I/O is involved?

If you can share with me how I can get started and how much it will cost me,
I would be greatly appreciated.

$500 + license fee for SQL Server 2008 Standard...


mfG
--> stefan <--

 

[Accesshelp]

Hi Stefan,

Thanks for your response.

As far as number of users, I will the only user; however, the data will be
at least 10GB before expansion.

I will use it for personal. Therefore, I have a very limited budget.

Unfortunately, Access nor SQL Express would not do the job due to size of
data.

Thanks.

 

[Stephen Raftery]

If you are the sole user, then Access may well be the right way to do it.
Your need for 100G of data seems strange - why so big?
If necessary, you could have one front-end file, and several back-end files,
each of which has a 4G limit. Would that work?

Stephen

 

[Steve]

How do you know you need 100GB?

Steve
(e-mail address removed)

 

[Accesshelp]

Stephen,

Thanks for your response. I have tried using several back-ends with Access,
and it would not work. The problem is when I run a query to pull the data
from multiple back-ends, Access creates a temporary file in a Temp folder.
When the temporary file hits 2GB, the query stops running.

I did the same with SQL Express, and it happened to me the same when it hit
4GB.

Thanks.

 

[John W. Vinson]

Hi Stefan,

Thanks for your response.

As far as number of users, I will the only user; however, the data will be
at least 10GB before expansion.

I will use it for personal. Therefore, I have a very limited budget.

Unfortunately, Access nor SQL Express would not do the job due to size of
data.

It does have some real problems and limitations, but you might want to
consider MySQL. Access can work as a frontend to it, and the price is right.

 

[Accesshelp]

Steve,

Thanks for your response. I do not need 100GB at this moment. I will,
however, need it in the future. For now, I need around 20GB for data and
query expansion.

Thanks.

 

[Accesshelp]

John,

Thanks for your response. How can I start MySQL?

 

[Accesshelp]

John,

I am looking for a database that can handle at least 20GB (or between 20GB
and 100GB). As I mentioned in my previous message, I have a very limited
budget to create that database. Unfortunately, Access nor SQL Server Express
would not do the job due to their size limitations.

What would you suggest? Thanks.

 

[John W. Vinson]

John,

Thanks for your response. How can I start MySQL?

Download it and run it:

http://www.mysql.com/

I've used it a bit, but I'm no sort of expert on it. The webpage has
tutorials, a downloadable executable, etc.

 

[Steve]

How do you know you need 20GB right now?

What do you mean by "data and query expansion"?

Steve
(e-mail address removed)

 

[Stephen Raftery]

I cannot help wondering whether you really need such an enormous database
with a singel user.
Can you give us any hints as to what this database does?

Stephen

 

[Steve]

Sorry, it's not my database. I can't help you!

Steve

 

[Accesshelp]

Stephen,

I have a set of data with minimum of 10GB. I have tried breaking up the
data into multiple back-end Access databases. When I tried to run a query on
those data from a front-end Access database. I could not because Access is
limited to 2GB. The same is with SQL Express, and it limits to 4GB.

Thanks.

 

[Sylvain Lafontaine]

Obviously, you need to go with MySQL if you cannot buy one of the regular
editions of SQL-Server.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[Accesshelp]

Sylvain,

Thanks for your response. Would you recommend SQL Server or MySQL, and why?
How much would cost me at minimum of each? Could you please also break the
costs down by hardware and software?

Thanks.

 

[Jeff Boyce]

Many of the responders have asked, but I've not seen your response yet.

WHAT data are you storing? Is this a database that contains truck parts,
.... or geographic/topological features, ... or pictures of zoo animals, ...
or ???

The reason I'm asking (and I assume others are) is because "HOW" depends on
"WHAT", and I still don't have a clear picture of what you are working on.

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Accesshelp]

Hi Jeff,

Thanks for your response. I am sorry for the delay in responding to your
message.

Due to confidentiality of the data that I am working on, unfortunately, I
can not share that information with you. I hope you understand.

Thanks.

 

[John W. Vinson]

Due to confidentiality of the data that I am working on, unfortunately, I
can not share that information with you. I hope you understand.

We don't need to see the data, but are the DATATYPES of the data confidential?
can you post a description such as the number of fields, this field being

65536 character text, that field being a date, the other field being a

number?