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
[MSc(I.T.), MCP, MCAD, MCSD]
Subscribe to:
Post Comments (Atom)
Article 
No comments:
Post a Comment