Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cognos79
Posting Yak Master
241 Posts |
 Posted - 2007-01-24 : 23:27:01
|
| 2005 express edition can hold 4 gb of information. how much a 4gb of data means. can we tell 4 gb = 100,000 records or something like this??? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-01-24 : 23:34:00
|
4GB see http://msdn2.microsoft.com/en-us/library/ms345154.aspx#sseover_topic4
KH |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-24 : 23:37:40
|
| We can't give you general formula like 4GB = 100000 records. It depends upon how many tables you have, how many and what type of columns you have, what is the row size, how many indexes you have on each table and what are their keys etc.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2007-01-25 : 11:38:58
|
| harsh...the spec doc for express edition says 1gb ram is required. is it true or does it work fine for 512 mb or 256 mb ram machines with kinda slow performance??? |
|
|
|
mikewa
Microsoft SQL Server Product Team
84 Posts |
Posted - 2007-01-30 : 18:32:37
|
| Hi cognos,What spec doc are you reading? The system requirements for RAM are a minimum of 192 MB with a recommened of 512 MB or higher. I think you may have confused the RAM recomendations with the maximum RAM limitation, which is 1 GB.Regards,Mike WachalSQL ExpressThis posting is provided "AS IS" with no warranties, and confers no rights.Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm |
|
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2007-02-02 : 13:45:20
|
| oh ok...thanks a lot mike |
|
|
|
|
|
|
2005 express edition