Files for Practicing SQL with SQL Server 2008 R2

I am looking for steps for installing Sql Server 2008 r2. My main use will be for practicing sql. My customer does not use Sql Server 2012.

I have looked at videos on youtube, but the installation for SQL Server 2008 r2 has drastically changed from the videos.

I have looked at microsoft, but the pages I have found don't say what the main files are.
LVL 1
Alex CampbellAsked:
Who is Participating?
 
geek_vjCommented:
If it is for practice, then try to get a developer edition from microsoft or on net.
Installing SQL Server 2008 R2 is pretty much easy if you want to go by default settings.
Its a prerequisite to install .Net framework before installing SQL Server 2008 R2.

Here is the step by step process of installing SQL Server 2008 (with images):

http://blog.sqlauthority.com/2008/06/12/sql-server-2008-step-by-step-installation-guide-with-images/

PS: SQL Server 2008 & 2008 R2 are similar in installation process so the above link holds good for both

If you have any queries, please do revert
0
 
Mike EghtebasDatabase and Application DeveloperCommented:
brb
0
 
Alex CampbellAuthor Commented:
Do you mean partitioning the hard drive? Is that needed?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Mike EghtebasDatabase and Application DeveloperCommented:
Sorry about removing my bad comment. I was reading Practicing Partitioning by mistake.

Now that I am at it, as you know, a table in a sql server could have records in millions. This makes the maintenance or search in the table very very cumbersome. So, the idea here is to create .ndf files where you store the data for the entire 2007, 2008, 2009 in their separate files like data2007.ndf, data2008.ndf, data2008.ndf.

So, what is partitioned is the a large table.

Mike
0
 
geek_vjCommented:
Alex,

Kindly post your question in a more detailed way. Are you looking for installing SQL Server 2008 R2 for practicing or you are planning to test partitioning in it?
0
 
Mike EghtebasDatabase and Application DeveloperCommented:
geek_vj,

Please ignore partitioning. It was my fault to write about it. He want to install for practice.
0
 
Alex CampbellAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.