Re: 2G limit in MSDE

Ah, what are you storing in the database? Don't tell me... let me guess....
ah... it's coming to me...
PICTURES! I got it right?...No? Documents?
These are BLOBs. If you want to save space, don't store the BLOBs in the
database--put them on CDs (if they are RO) or on other drives and put the
path and attributes in the database. File IO can far faster (6 to 10x) than
SQL query IO. Yes, it would require a change in your code, but it's not that
much trouble...

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Simon" <Simon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FA3B4343-37BD-4B74-8EF4-EFFA21EC7B66@xxxxxxxxxxxxxxxx
I am aware that there is a 2G limit in MSDE. However in some of our
production databases we are running out of space. There is a long term
plan
to upgrade to SQL2005 to double the space available to us. However in the
short term is there a quick way to have more space available ?

I could create a second database and then link a table / view back to the
original for example. Or would I be able to create a second filegroup
which
would have another 2 G ?

Any ideas ?

Si



.

Relevant Pages

  • Re: How To Add/Update Record In ADO.NET
    ... If the row is already there (there is already someone with the same name in the database), ... Hitchhiker's Guide to Visual Studio and SQL Server ... "Jeff Gaines" wrote in message ... SQL Server Compact Edition or Express Edition come to mind. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Which Method to Create a Database Do I Use?
    ... Okay, once the database is built, you have to get rights to access it. ... SSPI and "SQL Server" ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Which Method to Create a Database Do I Use?
    ... >> SQL Server Configuration Manager ... This mode assumes that the Windows User or IIS has rights to access the SQL Server itself and the database mentioned as the initial catalog in the Connection String. ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... "Jonathan Wood" wrote in message ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
Loading