Index Fragmentation in SQL Server 2005
New article on Index fragmentation posted in main website, check the article in the link below.
Index fragmentation is a phenomenon where the index contents are scattered. Normally the contents are in contiguous fashion which helps in fast retrieval of the underlying data. When the indexes are fragmented the data access becomes time consuming because of the scattered data that needs to be searched and read.
Index Fragmentation in SQL Server 2005
SQL Server 2005 Best Practices
New article on SQL Server 2005 Best Practices posted in main website, you can read the article from the link below.
How can I edit DTS packages in SSMS (Management studio)
Designing \ Editing DTS packages in SSMS is one of the question I'm seeing in forums, this situation occurs when an upgrade happens from SQL 2000 to SQL 2005. When SQL server 2005 was released it doesn't have a facility for editing \ designing DTS packages after upgrade. Even If you run upgrade advisor in that machine before upgrade you will be shown with a warning message as shown below.
SQL Server 2000 Meta Data Services packages are not supported
Existing Meta Data Services packages should be moved to SQL Server storage (in the msdb database) or to structured storage files before you upgrade. SQL Server 2005 does not install support for SQL Server 2000 Meta Data Services; therefore the Package Migration Wizard will be unable to access Meta Data Services packages after upgrade in the absence of the SQL Server 2000 Client Tools.