Questions on SQL Server
in [Tables]
|
From: Accesshelp on 6 Apr 2010 11:09 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.
From: Stefan Hoffmann on 6 Apr 2010 11:26 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 <--
From: Accesshelp on 6 Apr 2010 13:04 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 <-- > . >
From: Stephen Raftery on 6 Apr 2010 13:33 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 <-- > > . > >
From: Steve on 6 Apr 2010 14:13 How do you know you need 100GB? Steve santus(a)penn.com "Accesshelp" <Accesshelp(a)discussions.microsoft.com> wrote in message news:059B7DA5-3385-432E-A052-843AB31C53F4(a)microsoft.com... > 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.
|
Next
|
Last
Pages: 1 2 3 4 5 Prev: Text Field Size - Access 2007 Next: Any advice? Creating forms on the fly |