.net integration procedures, functions, triggers, and user defined types can be written using any .net language. This support was not there in 2000 where the only language was t-sql.
Reporting services 2005 has reporting services for reports which is a newly added features and does not exist in 2000. It was a special installation for 2000.
New data types 2005 has introduced two new data types varbinary (max) and xml. In 2000, we had image and text data types. The problem with these data types is that they assign same amount of storage irrespective of what the actual data size is.
Data Partitioning 2005 has introduced a feature called ‘data partitioning’ for large databases.
Rebuild indexes in 2005, building the clustered indexes does not built the nonclustered indexes.
Number of instances in 2000, there were maximum 16 instances. But in 2005, you can create up to 50 instances.
System catalog in 2000, system catalog was stored in the master database. In 2005, it’s been stored in resource database which is stored as sys object, and you cannot access this object directly.
Hyper threading 2005 supports hyper threading, which is a technology creates two logical processors on a single physical hardware processor.
Online indexing in 2005 indexes can be rebuilt online when the database is in actual production. In 2000 you cannot do insert, update, and delete operations when you are building indexes.
GUI changes query analyzer replaced by query editor, and enterprise manager replaced by management studio.
No comments:
Post a Comment