Questions on SQL Server
in [Tables]
|
From: John W. Vinson on 6 Apr 2010 17:08 On Tue, 6 Apr 2010 12:08:12 -0700, Accesshelp <Accesshelp(a)discussions.microsoft.com> wrote: >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. -- John W. Vinson [MVP]
From: Steve on 6 Apr 2010 18:43 How do you know you need 20GB right now? What do you mean by "data and query expansion"? Steve santus(a)penn.com "Accesshelp" <Accesshelp(a)discussions.microsoft.com> wrote in message news:F897495F-E721-44D0-BF9A-7BE3C1ADB3BC(a)microsoft.com... > 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. > > "Steve" wrote: > >> 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. >> >> >> . >>
From: Stephen Raftery on 7 Apr 2010 16:51 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" wrote: > How do you know you need 20GB right now? > > What do you mean by "data and query expansion"? > > Steve > santus(a)penn.com > > "Accesshelp" <Accesshelp(a)discussions.microsoft.com> wrote in message > news:F897495F-E721-44D0-BF9A-7BE3C1ADB3BC(a)microsoft.com... > > 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. > > > > "Steve" wrote: > > > >> 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. > >> > >> > >> . > >> > > > . >
From: Steve on 7 Apr 2010 19:34 Sorry, it's not my database. I can't help you! Steve <Stephen> wrote in message news:2BE3B621-FA33-4546-A9F9-ACB1CDA47867(a)microsoft.com... >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" wrote: > >> How do you know you need 20GB right now? >> >> What do you mean by "data and query expansion"? >> >> Steve >> santus(a)penn.com >> >> "Accesshelp" <Accesshelp(a)discussions.microsoft.com> wrote in message >> news:F897495F-E721-44D0-BF9A-7BE3C1ADB3BC(a)microsoft.com... >> > 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. >> > >> > "Steve" wrote: >> > >> >> 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. >> >> >> >> >> >> . >> >> >> >> >> . >>
From: Accesshelp on 7 Apr 2010 21:25 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. "Stephen Raftery" wrote: > 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" wrote: > > > How do you know you need 20GB right now? > > > > What do you mean by "data and query expansion"? > > > > Steve > > santus(a)penn.com > > > > "Accesshelp" <Accesshelp(a)discussions.microsoft.com> wrote in message > > news:F897495F-E721-44D0-BF9A-7BE3C1ADB3BC(a)microsoft.com... > > > 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. > > > > > > "Steve" wrote: > > > > > >> 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. > > >> > > >> > > >> . > > >> > > > > > > . > >
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 4 5 Prev: Text Field Size - Access 2007 Next: Any advice? Creating forms on the fly |