you can have a look in this article :

qa.sqlservercentral.com/columnists/rsharma/sqlserver2000improvements.asp

I learned a lot of thing with this article.

One thing that is missing on sql server 7 : function; there is...