SQL Server 100MB [英] SQL Server 100MB

问题描述

嗨


任何人都知道SQL Server 2000中有多少100MB？


它是不是很多？


谢谢

Kev

Hi

Anyone know how much 100MB is in SQL Server 2000?

Is it a lot?

Thanks
Kev

推荐答案

您可以在100MB SQL Server中存储大量数据数据库。


您可以存储多少数据也取决于是否使用良好的数据库维护实践

。

$ b例如，$ b常规日志截断会让你的数据库文件很小。

它应该每周至少完成一次。


运行" DBCC SHRINKDATABASE和DBCC SHRINKFILE帮助。


Juan T. Llibre

ASP.NET MVP

ASPNETFAQ.COM： http://www.aspnetfaq.com

=========== =======================

" Kevin Lawrence" < SP ****** @ spam.com>在留言中写道

news：3a ************************* @ news.rmplc.co.uk。 ..

You can store an awful lot of data in a 100MB SQL Server database.

How much data you can store would also depend on
whether good database maintenance practices are used.

Regular log truncation does wonders in keeping your db files small, for example.
It should be done at least once a week.

Running "DBCC SHRINKDATABASE" and "DBCC SHRINKFILE" helps.

Juan T. Llibre
ASP.NET MVP
ASPNETFAQ.COM : http://www.aspnetfaq.com
==================================
"Kevin Lawrence" <sp******@spam.com> wrote in message
news:3a*************************@news.rmplc.co.uk. ..

嗨

任何人都知道SQL Server 2000中有多少100MB？

是不是很多？
谢谢
Kev

Hi

Anyone know how much 100MB is in SQL Server 2000?

Is it a lot?

Thanks
Kev

我担心你可能会对这个问题得到一些轻率的回答。我想

您的问题可能是SQL Server 2000会产生多少存储空间开销吗？

所有100MB后都是100MB。对于存储文本，它是大量的空间。对于

图像，不是那么多。或者是辛普森一集的一集。


因为你还没有选择主持人（你担心100mb可能还不够）

确保你的主持人收取合理的升级费用。

" Kevin Lawrence" < SP ****** @ spam.com>在留言中写道

news：3a ************************* @ news.rmplc.co.uk。 ..

I''m afraid you might get some flippant answers to that question. I guess
your question might be "does SQL server 2000 incur much storage overhead?"
After all 100MB is 100MB. For storing text, it''s oodles of space. For
images, not so much. Or one episode of the Simpsons.

Since you haven''t chosen a host yet (and you fear 100mb might not be enough)
ensure that your host charges a reasonable fee for upgrading.
"Kevin Lawrence" <sp******@spam.com> wrote in message
news:3a*************************@news.rmplc.co.uk. ..

嗨

任何人都知道SQL Server 2000中有多少100MB？

是不是很多？
谢谢
Kev

Hi

Anyone know how much 100MB is in SQL Server 2000?

Is it a lot?

Thanks
Kev

>我担心你可能会对这个问题得到一些轻率的回答。我

> I''m afraid you might get some flippant answers to that question. I

猜你的问题可能是SQL Server 2000会产生多少存储开销吗？毕竟100MB是100MB。对于存储文本，它是空间的大量存储。对于图像，不是那么多。或者一集辛普森一家。


一些主要包含字符串数据，没有图像和没有视频的表格。

因为你还没有选择主持人（你担心100mb可能不够
确保您的主机收取合理的升级费用。

guess your question might be "does SQL server 2000 incur much storage
overhead?" After all 100MB is 100MB. For storing text, it''s oodles of
space. For images, not so much. Or one episode of the Simpsons.
A few tables containing mainly string data, no images and no videos.
Since you haven''t chosen a host yet (and you fear 100mb might not be
enough) ensure that your host charges a reasonable fee for upgrading.

我正在寻找一个

I''m looking at one that is

这篇关于SQL Server 100MB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！