Partitioning is nothing but dividing of datas according to the requirement to improve query performance. Consider you are having a table with large number of datas. Here in table partitioning we are going to implement horizontal partition, where the rows in the table will be based on one the column in table.
Advantages Database Mirroring:
Database Mirroring Vs Clustering
Microsoft SQL Server 2005 Upgrade Advisor is a tool you can use to prepare for upgrades to SQL Server 2005. Upgrade Advisor analyzes installed SQL Server 2000 or SQL Server 7.0 components, and then generates a report that identifies issues that you must or should address to before or after upgrading to SQL Server 2005.
This article will explain you in brief how to install upgrade advisor before installing SQL 2005
1.) Insert Sql 2005 setup CD DVD into drive and wait for auto menu to pop-up.