May 5, 2010 at 7:44 am
If I remember correctly, there is a new higher database size limit of 10GB in the new SQL 2008 r2 express. If that's the case, I'm wondering if this makes Express more viable for light, or even medium business use, assuming that a) data is pruned thoroughly and b) a viable third party set of applications to "simulate" SQL Server Agent is used (a few exist for 2005 I seem to remember).
Obviously, you would have to guarantee that the data never gets more than the 10GB limit, but I'm curious why Microsoft upped the limit when they risk selling less full versions?
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
May 5, 2010 at 8:33 am
My guess would be market penetration. The 4GB limit has caused me to waive off Express a few times because the base data was already too close to that to allow for more than a couple years of growth. If I knew that in 5 years they could upgrade to Standard and have the space for that I might be more open to express.
CEWII
May 5, 2010 at 8:55 am
As an alternative to SQL Server Agent, you could use Windows Scheduler and PowerShell scripts.
http://www.eggheadcafe.com/software/aspnet/30631798/server-2003-task-schedule.aspx
10 GB could accomodate an inventory of several hundred thousand items and tens of thousands of invoices, each with a hundred or more line items. There is still the 1 CPU and 4 GB memory limitation, so I'd suspect that slamming it with a heavy duty (and unoptimized) reporting process would probably make it non-responsive for other users.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply