Questions on SQL Server
in [Tables]
|
From: Sylvain Lafontaine on 8 Apr 2010 01:40 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" <Accesshelp(a)discussions.microsoft.com> wrote in message news:C83E3A12-197E-42EF-9508-F99D8420C08D(a)microsoft.com... > 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. >> > >> >> > >> >> > >> . >> > >> >> > >> > >> > . >> >
From: Accesshelp on 8 Apr 2010 08:11 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. "Sylvain Lafontaine" wrote: > 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" <Accesshelp(a)discussions.microsoft.com> wrote in message > news:C83E3A12-197E-42EF-9508-F99D8420C08D(a)microsoft.com... > > 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. > >> > >> > >> > >> > >> > >> . > >> > >> > >> > > >> > > >> > . > >> > > > > . >
From: Jeff Boyce on 8 Apr 2010 11:12 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" <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 15 Apr 2010 21:28 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. "Jeff Boyce" wrote: > 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" <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: John W. Vinson on 15 Apr 2010 21:45 On Thu, 15 Apr 2010 18:28:01 -0700, Accesshelp <Accesshelp(a)discussions.microsoft.com> wrote: >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? -- John W. Vinson [MVP]
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 4 5 Prev: Text Field Size - Access 2007 Next: Any advice? Creating forms on the fly |