SQL6.5,7,2000 and 2005

Question

SQL6.5,7,2000 and 2005

karthik M

One Orange Chip

Points: 29139
More actions
January 10, 2008 at 2:31 am

#70693

Experts,
I am going to take a session about 'Difference between Sql6.5,7,2000 & 2005 on first week of february in my office.It is mandatory.My RM has given topics to everybody.
I need the answer in the below format.
1) From the SQL Developer Perspective ( no need to include all functions,because i know there are lot of lot of undocumented commands and normal commands which have been introduced in each version,so i need some important commands list)
example:
ROWID() Function TOP Clause in UPDATE
Sql6.5 No No
Sql7 No No
sql2000 Yes No
sql2005 Yes Yes
2) From the SQL DBA Perspective
(Please refer the above format)
3) From the Database Designer Perspective
(Please refer the above format)
4) From the Database Architecture Perspective
(Please refer the above format)
i have started to gather information.I know some experts would come to front row for me to beautify my presentation.
Thanks in advance.
karthik

Viewing 15 posts - 1 through 15 (of 15 total)

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

David.Poole SSC Guru Points: 75896 More actions · Answer 1

This is a mamoth task. I would omit SQL6.5 from the presentation. In about 4 years time there will be DBAs working who were not born when SQL6.5 was deprecated.

LinkedIn Profile

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

Karthik,

You, of all people, should know better... get onto the Microsoft web site and look for "What's new in" each of the different versions. Do some of your own work... We're not going to write your bloody presentation for you 😛

A good "Senior Software Engineer" should have no problem with such a task 😉

--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: 734434 More actions · Answer 3

Unless you are using 6.5, doesn't make sense to look back at this version or the changes in 7.

And Books Online for each version has this information.

karthik M One Orange Chip Points: 29139 More actions · Answer 4

Jeff,

I have already gathered informations.I think you were understood my question wrongly.

karthikeyan
Posted 1/10/2008 9:31 AM
i have started to gather information.I know some experts would come to front row for me to beautify my presentation.

I have asked some suggestions and highlighting points from good experts to add it in my presentation.

We're not going to write your bloody presentation for you 😛

I didn't asked you to write for me.;)

karthik

Jeff Moden SSC Guru Points: 1003857 More actions · Answer 5

Perhaps it's the language barrier, but it looked to me that you wanted us to give you all of the differences between the different versions for you to write your presentation. It didn't look, from what you asked, that you were going to do any research on your own.

Perhaps it would have been better to ask "Where can I find out what all the differences between the various versions of SQL Server are." As a sportsman might say, "It's all in the wrist" and on a forum, where we cannot benefit from tonal inflection, etc, it's all in what you ask. Very slight change in what you ask will change the perception of the reader from "What an arrogant SOB he is" to, "Oh, good question... lemme see if I can help." 🙂

It's a very important technique to learn to survive in business... 😉

--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)

karthik M One Orange Chip Points: 29139 More actions · Answer 6

Jeff,

one thing is very clear,I am not a arrogant SOB.

karthik

karthik M One Orange Chip Points: 29139 More actions · Answer 7

Jeff,

one thing is very clear,I am not an arrogant SOB.

Really i am expecting some good answers or suggestions.

karthik

Jeff Moden SSC Guru Points: 1003857 More actions · Answer 8

Then, you need to do as I said... check out the "What's New" section of each release on the Microsoft website.

--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)

Lester Policarpio SSCertifiable Points: 7109 More actions · Answer 9

Just like human torch said "Flame On!!!!" peace to all :):D

"-=Still Learning=-"

Lester Policarpio

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 10

Hi, folks!

This is a forum to discuss the topics we are all interested. It is not a battle field. My understanding is that Jeff was kidding (from the icon he used). Please do not take it in person.

I am also interested in the differences between SQL 2000 and 2005. It will be much easier to learn for experienced SQL 2000 DBA.

Any input (a link, or ...) on the difference will be greatly appreciated.

Jeff Moden SSC Guru Points: 1003857 More actions · Answer 11

Lester Policarpio (1/22/2008)
Just like human torch said "Flame On!!!!" peace to all :):D

It was a real life coach... I think Karthik can go a long way if he changes his wording just a bit. If you had been following his posts all along, you'd know that he's been asking for help on vocabulary and the like and it certainly wasn't meant as a put down.

Go back and look at the tone of my email... it was meant as friendly advice. If you don't like the tone, then practice what you preach... Peace to all, please drive through 😛

--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)

Sergiy SSC Guru Points: 110206 More actions · Answer 12

Jeff,

should I post couple replies?

Just to show how good you are to OP.

:hehe:

_____________
Code for TallyGenerator

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 13

Everyone please take a step back and calm down. I don't think Jeff meant anything, but everyone please discuss the topic only.

Lester Policarpio SSCertifiable Points: 7109 More actions · Answer 14

Jeff Moden (1/22/2008)
Lester Policarpio (1/22/2008)
Just like human torch said "Flame On!!!!" peace to all :):D
It was a real life coach... I think Karthik can go a long way if he changes his wording just a bit. If you had been following his posts all along, you'd know that he's been asking for help on vocabulary and the like and it certainly wasn't meant as a put down.
Go back and look at the tone of my email... it was meant as friendly advice. If you don't like the tone, then practice what you preach... Peace to all, please drive through 😛

Yep I Agree 🙂 that is why i wrote "Flame on" because the topic became very hot but it doesnt mean im against someone... I just felt that we just need to take a deep breath before the topic changes to something. 🙂

"-=Still Learning=-"

Lester Policarpio