Hi, All.
New to SQL. Just downloaded SQL server Express 2005, Web doc says its max limit is 4GB,
Need to know how large a 4GB can hold. The data shall be like holding company info, say: company names, locations, line of business, phone, etc. It needs full-text search on it.
Is this Express is the choice to go?
4 GB is a LOT. First of all, it's 4294967296 characters. But it's compressed in the database, so it's actually more.
|||
My concern is, it is web based, once start running on web, it just might soon reach the limit. I've never done database before./(or serious programming for that matter.). So need to know a clue for a comparison. say, for an example, how many books of yellow-page-like data type that a 4 GB of MS SQL SERVER Express can hold?
Thanks
|||Honestly, you're worrying about nothing. Did you see how big the number was that I quoted ? It won't be an issue.
|||
Really?
BTW 4GB is 4 gigabyte, which equal to 4 billion characters, if character set is one byte wide. If I go international, I need cut that number in half.
|||Yeah, I know that unicode is half that, but I didn't want to muddy the waters. If it's 4 billion exactly, that's not a real gigabyte. Whatever.
Either way, I still think you're worried over nothing. Use SQL Express, and if you run into trouble, migrate to SQL Server. Don't worry about stuff before you need to - 4 gig is a lot of data.
No comments:
Post a Comment