A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Questions on SQL Server



 
 
Thread Tools Display Modes
  #1  
Old April 6th, 2010, 04:09 PM posted to microsoft.public.access.tablesdbdesign
AccessHelp
external usenet poster
 
Posts: 161
Default Questions on SQL Server

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.
  #2  
Old April 6th, 2010, 04:26 PM posted to microsoft.public.access.tablesdbdesign
Stefan Hoffmann
external usenet poster
 
Posts: 991
Default Questions on SQL Server

hi,

On 06.04.2010 17:09, Accesshelp wrote:
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 --
  #3  
Old April 6th, 2010, 06:04 PM posted to microsoft.public.access.tablesdbdesign
AccessHelp
external usenet poster
 
Posts: 161
Default Questions on SQL Server

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.

"Stefan Hoffmann" wrote:

hi,

On 06.04.2010 17:09, Accesshelp wrote:
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 --
.

  #4  
Old April 6th, 2010, 06:33 PM posted to microsoft.public.access.tablesdbdesign
Stephen Raftery[_3_]
external usenet poster
 
Posts: 9
Default Questions on SQL Server

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


"Accesshelp" wrote:

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.

"Stefan Hoffmann" wrote:

hi,

On 06.04.2010 17:09, Accesshelp wrote:
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 --
.

  #6  
Old April 6th, 2010, 07:17 PM posted to microsoft.public.access.tablesdbdesign
AccessHelp
external usenet poster
 
Posts: 161
Default Questions on SQL Server

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.

"Stephen Raftery" wrote:

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


"Accesshelp" wrote:

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.

"Stefan Hoffmann" wrote:

hi,

On 06.04.2010 17:09, Accesshelp wrote:
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 --
.

  #7  
Old April 6th, 2010, 07:28 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Questions on SQL Server

On Tue, 6 Apr 2010 10:04:17 -0700, Accesshelp
wrote:

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.
--

John W. Vinson [MVP]
  #9  
Old April 6th, 2010, 08:08 PM posted to microsoft.public.access.tablesdbdesign
AccessHelp
external usenet poster
 
Posts: 161
Default Questions on SQL Server

John,

Thanks for your response. How can I start MySQL?

"John W. Vinson" wrote:

On Tue, 6 Apr 2010 10:04:17 -0700, Accesshelp
wrote:

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.
--

John W. Vinson [MVP]
.

  #10  
Old April 6th, 2010, 08:14 PM posted to microsoft.public.access.tablesdbdesign
AccessHelp
external usenet poster
 
Posts: 161
Default Questions on SQL Server

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" wrote:

On Tue, 6 Apr 2010 10:04:17 -0700, Accesshelp
wrote:

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.
--

John W. Vinson [MVP]
.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:35 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.