Tuesday, May 23, 2006

Enhancements in SQL Server 2005 - Part III

I'm reading: Enhancements in SQL Server 2005 - Part IIITweet this !
Enhancements in full-text search are as follows:

1) Support for full text search against linked servers
2) No limitations of using either one or all the columns in a table, you can now specify whichever columns you require in the column_list argument.
3) Full-text queries using a different language to the default column language.
4) Full-text catalogs can now be backed up and restored with or without the database data.
5) Full-text catalogs are included in attach and detach operations.
6) Full-text indexes can be created on XML data.
7) Performance of index population is improved.

SQL Server Integration Services

SQL Server Integration Services (SSIS) provides a comprehensive solution for transferring and transforming data between diverse data sources.

1) SSIS has been redesigned to separate package-control flow from data flow. Two engines have been introduced to handle these aspects of data transformation: the SSIS Run-time engine and the SSIS Data-Flow engine.
2) SSIS Designer is hosted in Business Intelligence Development Studio or SQL Server Management Studio.
3) Provides many built-in transformations
4) Management and Deployment has become easy as you can choose to deploy a SSIS package using design time deployment or the SSIS Installer.

Siddharth Mehta

No comments:

Related Posts with Thumbnails