On 2/1/06, Greg Twyford <[EMAIL PROTECTED]> wrote: > Cedric Meyerowitz wrote: > > Another user made following comments on another forum www.ausgp.com > > > > "I am of the belief that this was due to the lack of knowledge of the MSDE > > product by the programmers at HCN. I believe that they falsely understood > > that there is a 2GB per instance limit on MSDE. This is obviously not the > > case. There is a 2Gb per database limit, but some 64K databases per instance > > which equates to a maximum of 64K x 2GB = 128Tb data per MSDE instance. > > > > I know of other clinical software providers that aren't interested in using > > MSDE to it's full capacity, with a believe that either the mystical 2GB > > limit or the concurrency governing restrictions would have a substantial > > impact on a large practice. I believe that BP's programming shows this to be > > incorrect as BP seems to be happily running on MSDE in large practices with > > large databases. " > > > > As you can see the 2GB limit problem is not a problem. Hence BP has had no > > problems in large practices because Frank did his homework and hence is a > > better programmer. > > > > It is important that we do not spread this false rumour of the 2GB limit, > > because we then show users we know as little as the scaremongers. > > > > Cedric > > Cedric, > > That is very interesting information about MSDE. I recall going to the > Microsoft site to research the MSDE versus MS SQL question and coming > away with the sense the '2GB per database' limit for MSDE meant what it > sounded like. This concept of instances is new to me, and from your > quotation seems to nearly equate to tables in a DB, or rows in spreadsheet. > > I'd be interested to know what an 'instance' in a 'database' actually > means in SQL-speak. If it means that a 'database' in the sense I > understand it - in this context all the data one would enter into MD3 - > can be a lot more than 2GB in total - then fine. > > It still seems odd that MS would allow a very large DB with very > limiting restrictions on the number of users, in the context of having > MSDE as a teaser for their 'full-sized' product. Maybe the fuzziness > over the 2GB limit has been primarily for the purpose of encouraging > uptake of MS SQL. >
An 'instance' is what you connect to.. so it's not addressable via SQL (the language). You can install multiple SQL Server instances on one machine; they'll have different names, listen on different ports, etc. To further confuse: the name of the latest version of MSDE is "SQL Server 2005 Express Edition", and the database size limit has been increased from 2GB to 4GB. doug. _______________________________________________ Gpcg_talk mailing list [email protected] http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
