2G limit in MSDE

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
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@.discussions.microsoft.com> wrote in message
news:FA3B4343-37BD-4B74-8EF4-EFFA21EC7B66@.microsoft.com...
>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
>
|||Check out reindexing with a smaller fill factor.
--DatabaseAdmins.com
Remote DBA Services
"William (Bill) Vaughn" wrote:

> 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@.discussions.microsoft.com> wrote in message
> news:FA3B4343-37BD-4B74-8EF4-EFFA21EC7B66@.microsoft.com...
>
>
|||Bill
do you know much about the varbinary method for storing documents?
I read somewhere that you can stored docs as varbinary instead of image and
it's a lot lot lot faster-- but it only works with small docs
thanks
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:ejV$Kw0XHHA.3952@.TK2MSFTNGP04.phx.gbl...
> 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)
> ----
---[vbcol=seagreen]
> "Simon" <Simon@.discussions.microsoft.com> wrote in message
> news:FA3B4343-37BD-4B74-8EF4-EFFA21EC7B66@.microsoft.com...
the[vbcol=seagreen]
the
>
|||partition your older data into an archive table-- in a different database
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:FA3B4343-37BD-4B74-8EF4-EFFA21EC7B66@.microsoft.com...
> 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
>
|||My tests (albeit unscientific at times) shows storing BLOBs (in whatever
datatype) in the database is 6x slower than storing the same data on a file.
Your mileage may vary.
____________________________________
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)
------
"Aaron Kempf" <akempf@.dol.wa.gov> wrote in message
news:eBBZVECjHHA.1240@.TK2MSFTNGP04.phx.gbl...
> Bill
> do you know much about the varbinary method for storing documents?
> I read somewhere that you can stored docs as varbinary instead of image
> and
> it's a lot lot lot faster-- but it only works with small docs
> thanks
>
> "William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
> news:ejV$Kw0XHHA.3952@.TK2MSFTNGP04.phx.gbl...
> guess...
> than
> that
> rights.
> the
> the
>