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 |
|
nethervoid
Starting Member
12 Posts |
 Posted - 2005-10-03 : 13:54:28
|
| Another strange situation (strange situations seem to develop when non-IT people plan anything IT):So I'm supposed to develop and administer a SQL DB, BUT I can't consult our IT department about it because they were originally supposed to help with the development/administration via a project to do so, but over a 6 month period managed to not do a thing to get it going.I have to find a way to develop/run/administer a 170mil+ record data warehouse/20 gigs without consulting IT except to get the software and procure server space. Only problem is, the only way to get server space is to create an IT project.How large of a DB can I run from a local workstation? Say if I only am going to run Personal edition, so I don't have to load the DB on a Win Server box? We have a local box we can run it on. Still, we're going to have to procure a copy of SQL personal edition. Have to go through IT for that too. lolI think this would be the only way to totally circumnavigate IT on this size of a DB.Any thoughts? |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-10-03 : 14:53:14
|
| I run a 4Gb SQL 2000 DB on my personal workstation so I can pre-test before testing on my testing server. (This sounds like a setup line.)I'd suggest installing a development version of SQL 2000 (or 2005) on your workstation. |
 |
|
|
nethervoid
Starting Member
12 Posts |
Posted - 2005-10-03 : 19:04:28
|
| So I guess my real question is, how large a DB can I run on the personal edition? Or MSDE? |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-10-03 : 19:15:19
|
| Yep, install developer edition on your workstation. I test 30GB+ Databases on my workstation. Needless to say, you better have a lot of RAM and some fast HDD's to get anything done in any reasonable period of time with your datawarehouse. You need at least 2GB's of RAM and some sort of RAID 0 or 1/0 array.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda> |
|
|
|
nethervoid
Starting Member
12 Posts |
Posted - 2005-10-04 : 11:23:37
|
| Hmm. The thing is, the warehouse is only going to be used by a group of approximately 10 users. The only reason we aren't using access is the size of the dataset.Probably have to run Workstation edition. Although our local box would have to be beefed up. It only has 256 megs of ram. |
|
|
|
|
|
|
SQL edition types/installation options vs DB needs