building an SQL server from scratch abeg help

Lanju · 05-02-2007, 05:06 PM

Hi guys
abeg i have a lil project im working on. i intend to deploy sql server for testing purposes.
Need a simple walkthrough document i can use for reference.
Im going to download the trail product and install on xp and linux. wait o, e be like say u no fit install on xp shebi na windows server 2003 or win2k?

feedback is much appreciated ooo, cos this gives me a £££££ payrise

djmightymike · 05-02-2007, 05:59 PM

Both SQL 2K and 2K5 will run on windows with no issues.

A few Gotchas:
The enterprise edition for Full blown SQL 2K will not install on XP. You will have to install the developer edition. I think on 2K3 you can install the enterprise version. I doubt you can host SQL server on a unix/linux box, but i might be wrong.

SQL server is not free. however the free versions (MSDE and SQL 2K5 Express are both free). The database engines are the same in both the free versions and the full enterprise versions. The only difference is that in MSDE, which is the free version of SQL2K, the Physical size limit of the DBase is set at 2GB and there is a governor that restricts the number of concurrent transactions in the threadpool to 10. Once you begin executing more than 10concurrent transactions, Performance suffers.

In SQL 2k5 express, which is again the free version of the full server version, MS increased the size limit to 4GB, and opened up the freeway, thus removing the restriction on the number of concurrent transactions. However the amount of memory you can reserve for use has been limited to 2GB which is really not bad considering it's free

.

Refer to the msdn site for how to setup a SQL server or i can walk you thru it live for a 500K vbux

. it's a walk in the park.
it can indeed increase your earnings sha, but it can get boring and repetitive too.

bettybogus · 05-04-2007, 02:47 AM

Do you have XP home or Professional?
SQL Server requires Professional.. cos IIS comes standard on Pro..
Anyways.. you can work around this..
Download and install:
SQL Server 2005 Express Edition
&
SQL Server Management Studio Express

It doesn't have the full functionality that SQL server does, but it works just fine for development purposes..

sapphire · 05-04-2007, 06:45 AM

^^yeah i have SQL express on my laptop and it works perfectly.

Lanju · 05-07-2007, 05:06 PM

thx got it

want to work with some sample tables. im not a dba just use it to trigger queries for testing purposes. but i dey set up enviroment too

05-02-2007, 05:06 PM	#1 (permalink)
Lanju "RAZZOID OF NR" Join Date: Mar 2001 Location: Baffing outside with Okpabio Posts: 28,876 Points: 1,082,038,585.15 Bank: 426.71 Total Points: 1,082,039,011.86 Donate Rep Power: 21474916	building an SQL server from scratch abeg help Hi guys abeg i have a lil project im working on. i intend to deploy sql server for testing purposes. Need a simple walkthrough document i can use for reference. Im going to download the trail product and install on xp and linux. wait o, e be like say u no fit install on xp shebi na windows server 2003 or win2k? feedback is much appreciated ooo, cos this gives me a £££££ payrise __________________ if you are going to put weave in your hair, please use human hair cos the synthetic fake plastic shit tastes wierd after hugging you

05-02-2007, 05:59 PM	#2 (permalink)
djmightymike Registered User Join Date: Dec 2006 Location: Festac Town Posts: 8,638 Points: 1,278,100,513.38 Bank: 0.02 Total Points: 1,278,100,513.40 Donate Rep Power: 21474865	Both SQL 2K and 2K5 will run on windows with no issues. A few Gotchas: The enterprise edition for Full blown SQL 2K will not install on XP. You will have to install the developer edition. I think on 2K3 you can install the enterprise version. I doubt you can host SQL server on a unix/linux box, but i might be wrong. SQL server is not free. however the free versions (MSDE and SQL 2K5 Express are both free). The database engines are the same in both the free versions and the full enterprise versions. The only difference is that in MSDE, which is the free version of SQL2K, the Physical size limit of the DBase is set at 2GB and there is a governor that restricts the number of concurrent transactions in the threadpool to 10. Once you begin executing more than 10concurrent transactions, Performance suffers. In SQL 2k5 express, which is again the free version of the full server version, MS increased the size limit to 4GB, and opened up the freeway, thus removing the restriction on the number of concurrent transactions. However the amount of memory you can reserve for use has been limited to 2GB which is really not bad considering it's free . Refer to the msdn site for how to setup a SQL server or i can walk you thru it live for a 500K vbux . it's a walk in the park. it can indeed increase your earnings sha, but it can get boring and repetitive too. __________________ The Lord is my Shepherd -Psalms 23 http://djmightymike.net http://truspotradio.com http://myspace.com/naijadjs http://myspace.com/dj_mightymike

05-04-2007, 02:47 AM	#3 (permalink)
bettybogus Mami Wata Join Date: May 2003 Location: Under the sea Posts: 17,591 Points: 77,006.55 Bank: 1,902,669.48 Total Points: 1,979,676.03 Donate Rep Power: 3212561	Do you have XP home or Professional? SQL Server requires Professional.. cos IIS comes standard on Pro.. Anyways.. you can work around this.. Download and install: SQL Server 2005 Express Edition & SQL Server Management Studio Express It doesn't have the full functionality that SQL server does, but it works just fine for development purposes.. __________________ Bonita Applebum..y'know..like a hip hop song.. Like a perfect verse, over a dope beat.. ~~~~~~~ Jesus take the wheel.. Last edited by bettybogus; 05-04-2007 at 04:10 AM..

05-04-2007, 06:45 AM	#4 (permalink)
sapphire Registered User Join Date: May 2002 Location: ha! Posts: 2,589 Points: 10,014.60 Bank: 604.82 Total Points: 10,619.42 Donate Rep Power: 215999	^^yeah i have SQL express on my laptop and it works perfectly. __________________ If my father has stolen, I will... Attend the very best school in the world and walk shoulder high (Educational Investment) Organize charity fund just like the 'better life For Rural Women' and government officials will contribute more (...talk about the rich getting richer) Own properties in choice countries/ locations and drive 'tear rubber' vehicles (property Investment) Be the toast of the town where musician will sing praise me (Social well being) Owning a jet or airplane wouldn't be an issue (Ease of transportation) Streets/avenues will be named after me (grass root investment) Arrange prayers for my father in churches and mosques to ward off evil spirit and untimely death (Spiritual upliftment) Advice my father to marry more wives and take more chieftaincy tittles across the board (evenly distribution of wealth) Donate 'chairs' to tertiary institutions for under privilege children Have shares in blue chips companies ** Wouldn't have to struggle in life But my father didn't have the opportunity to steal otherwise I wouldn't be in diaspora searching for the proverbial green pastures. http://www.nigeriavillagesquare.com/...s-a-thief.html

05-07-2007, 05:06 PM	#5 (permalink)
Lanju "RAZZOID OF NR" Join Date: Mar 2001 Location: Baffing outside with Okpabio Posts: 28,876 Points: 1,082,038,585.15 Bank: 426.71 Total Points: 1,082,039,011.86 Donate Rep Power: 21474916	thx got it want to work with some sample tables. im not a dba just use it to trigger queries for testing purposes. but i dey set up enviroment too __________________ if you are going to put weave in your hair, please use human hair cos the synthetic fake plastic shit tastes wierd after hugging you

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode