Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bernard Bout
  Where is Bernard Bout?
 Bernard Bout
 To: Anders Altberg
  Where is Anders Altberg?
 Anders Altberg
Subject: RE: Msde
Thread ID: 209110 Message ID: 209319 # Views: 1 # Ratings: 0
Version: Not Applicable Category: Databases, Tables and SQL Server
Date: Saturday, December 27, 2008 7:17:48 AM         

> > Hey guys
> >
> > I got big load of data but i have to put it in two tables i want to put it in one does anyone know of anyfree SQL i herd MSDE has 4GB limit but anything up to date that has same sort of speck,
> >
> > cheers,
> >
> > Ty
> MSDE is history but its successor "Sql Server Express" is free and each database is max 4GB.
> -Anders

What people don't realise is that the Database size limit is 4GB. This means that the database file cannot exceed 4gb. This can be a limiting factor if you have few large tables. You can easily exceed the 4gb limit since there is a lot more stored in a database than just your tables and data.

For instance our database where I work is 54 GB in size for about 120000 members data. I can only get it to fit on Express by limiting the members to about 1000. After that I have to spend $$$ in the thousands and buy a full blown server.

It's ok to use for a few small web sites and sample programs but for any reasonable size app you find out very soon that your decision to use the free Express is now going to cost you big bucks.

Or you will have to split your tables across a number of databases.


** If you see someone without a smile, give em one of yours :) **
My Blog 8-)


Msde Posted by Tyrone Matthews @ 12/24/2008 11:00:44 AM
RE: Msde Posted by Anil Sharma @ 12/24/2008 11:13:31 AM
RE: Msde Posted by Anders Altberg @ 12/24/2008 12:53:07 PM
RE: Msde Posted by Bernard Bout @ 12/27/2008 7:17:48 AM
RE: Msde Posted by Cetin Basoz @ 12/24/2008 1:43:46 PM
RE: Msde Posted by Bernard Bout @ 12/27/2008 7:10:55 AM
RE: Msde Posted by Patrick McGreevy @ 12/29/2008 1:41:48 AM