August 8, 2008 at 12:41 am
Hi, most of the developers and IT people whom I interact daily ask me the same question What is the difference b/w 2000 and 2005?
What are the new features in 2005?
I try to explain them with some of the features\difference which they get confused as whether it is a difference or new features.
Some of the difference is given below.
Varchar(max) upto 2 GB,IDENTITY(MAX),Indexed views.
New features are:
TRY CATCH BLOCK,Table partitioning,Schema instead of user,Online Indexing, DDL Triggers,Dynamic Management views & functions,database snapshot.
What I\they want is the difference and new features according to their weight i.e if someone ask the same two question specifying top 10 difference and new features I should be able to explain them in a desc order giving the most important difference or new features the first preference and the next important difference or new features the second preference. So can I know difference or new features in their descending order according their weight from our DBA point of view?
August 8, 2008 at 1:31 am
If you do not have very large tables then table partitioning is most likely to be useless for you. If you do, it may be a lifesaver. This is just one example where a feature/difference has a completely different value depending on the environment it is used in. You should look at all the new features, and try to find out if they are applicable to your organization/servers, and prioritize them based on how they can improve/solve problems you currently have or will have in the future.
- Andras
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply