SQL Server 2000 compared to ver 7

[geokor]

Im new to this forum. Haven't used SQL Server for a couple of years (been working with MySQL mostly). Anyways, looks like Im going to be learning SQL Server 2000. Is there a big difference between ver 7 and 2000? I've looked at MS's site and haven't seen too much difference (not real differences anyways.)

Thanks for the input.

George K

 

[tlbroadbent]

SQL 2000 is versioned as SQL 8. However, it is more like SQL 7.5. The core product hasn't changed much. However, there are several significant changes - USFs, Table variables, IndexDefrag, built-in XML support, Instead of triggers, indexed views, distributed partioned views, cascading referential integrity constraints have been added, etc.

There are significant improvements in DTS. The compiler/optimizer does a better job creating query plans. Overall SQL Server performance is better. Collation can be specified at the database and column level rather than only at the server level. Multiple instances of SQL Server can run on one server. And so forth...

See SQL BOL for a complete list of enhancements and changes.

http://msdn.microsoft.com/library/en-us/whatsnew/wn_whatnew_6a2b.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[SQLSister]

Threre are some new data types, you can create User defined functions (a big plus, we use these all the time!), there are some indexing enhancements, etc. See BOL under what's new for the complete list. But most of what you know from SQL 7 will work.

 

[geokor]

Thank you! This is exactly what I wanted to know - and the link is especially helpful. George K

...the foolishness of men! When they are learned they think they are wise.