January 13, 2003 at 4:13 pm
At one time, I saw a document on the web that states the differences in SQL2000 and SQL v.7. Does anyone know where such document exists?
Thanks
January 16, 2003 at 8:00 am
This was removed by the editor as SPAM
January 16, 2003 at 10:37 am
Books Online goes into some of the enhancements. Is there a particular area you are looking at?
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
January 16, 2003 at 12:34 pm
No particular topic. I'm a system DBA. In trying to get our applications converted to SQL2000, one of the application DBAs asked for a list of differences. I can check BOL though, or just recommend that he do so. Thanks for your reply Steve.
January 16, 2003 at 2:59 pm
Some I know of right off the top that are pluses (at least to some).
1) New table variable data type. Usefull for small temp tables, avoiding some tempdb stuff and return sets from functions.
2) User Defined Functions, basically works like an inline SP in a select statement but there are some conditions how much so.
3) You can make comments on various things like columns, tables, etc making documentation a little more self handled and easier on coders who are don't like doing normal documentation.
4) The bigint variable data type, gives a large identity and numeric value.
5) Text in row for text data type in a table.
6) They have streamlined a few things within the query engine.
7) Several new builtin functions.
8) Ability to DEFRAG and index as opposed to rebuilding it.
9) Ability to have various collations at the DB and table levels.
10) Indexed views.
11) SP are now compiled before runtime.
12) New options for Triggers.
13) Cascading Updates and Deletes built in thru relationships.
Some others but my mind just blanked on the rest of the list. This is all new or changed in SQL 2000.
January 16, 2003 at 3:04 pm
14) Multiple Instances on one server
(Max of 16 instances. 32,767 databases in each)-- Great for Enterprise Server
15) Log Shipping
January 17, 2003 at 10:32 am
There is a pretty good Microsoft FAQ at http://www.microsoft.com/sql/evaluation/overview/WhatsNew.doc which summarizes things pretty well. Also some things are obvious after installation. I like the Browse functionality that's now built inot the Query Analyzer...don't have to go back and forth so much to Enterprise Manager.
BOL should include this information but doesn't to my knowledge. Good luck!
My hovercraft is full of eels.
January 17, 2003 at 12:47 pm
Thank you very much. It's exactly what I was looking for!
January 21, 2003 at 10:20 am
Although it is handy to see the "What's New", does anyone know where to find concrete information on performance benchmarks between SQL2K and SQL 7.0 - if any?
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply