New to SQL

Question

New to SQL

colincoates55

Grasshopper

Points: 13
More actions
December 20, 2009 at 12:57 pm

#136863

I am new to SQL Databases. I am learning SQL2005. Should I really be learning SQL2008 as that is the latest version

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Dugi SSCoach Points: 17998 More actions · Answer 1

...what ever you learn SQL Server 2005 or 2008 will be welcome for you... I recommend to learn SQL Server 2008, it includes also SQL Server 2005 and more than SQL Server 2005. You should go with the time, you should be in with SQL Server 2008!

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Jeff Moden SSC Guru Points: 1004405 More actions · Answer 2

My recommendation would be to read the following article before you do anything...

http://www.sqlservercentral.com/articles/DBA/68526/

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 3

Jeff has a great link there, but what's your job? What are you supposed to be doing with SQL 2005?

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 4

Are you learning for yourself or for your business? If your business, learn what they're using. For yourself, go to 2008. Anything you learn there is not wasted, it transfers down to 2005 fairly well, and you'll look current.

Read Jeff's link.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning