Đang chuẩn bị liên kết để tải về tài liệu:
Microsoft Press microsoft sql server 2005 PHẦN 10

3. Cấu hình các thuê bao và thuê bao. Trong bài học này, bạn sẽ thấy làm thế nào để sử dụng SSMS để thực hiện các bước sau để cấu hình một nhóm sao chép. Bạn cũng thấy làm thế nào để tạo ra các kịch bản Transact-SQL cấu hình tương đương. | Chapter 21 Creating Full-Text Catalogs SQL Server like all database platforms is built to store and retrieve large amounts of data. The system enables efficient data management by imposing a structure on the data it stores in its tables. However not all data has a well-defined structure and not all queries conform to basic true false rules for retrieving data. To manage this type of data and its associated queries other platforms rely on third-party tools. But SQL Server s Full-Text Search component provides a powerful and flexible feature called full-text indexing to manage queries issued against unstructured data. This chapter provides an overview of full-text search elements and terminology explains how to create full-text catalogs and indexes and shows how to populate the indexes and keep them up to date. Then the chapter shows you how to execute full-text queries to search full-text indexed columns for matching words. Exam objectives in this chapter Implement a full-text search. Create a catalog. Create an index. Specify a full-text population method. Lessons in this chapter Lesson 1 Creating a Full-Text Catalog.817 Lesson 2 Creating a Full-Text Index.820 Lesson 3 Populating a Full-Text Index.825 Lesson 4 Querying Data by Using a Full-Text Index.828 Before You Begin To complete the lessons in this chapter you must have SQL Server 2005 installed. Full-text indexing installed. A copy of the AdventureWorks sample database installed in the instance. 813 814 Chapter 21 Creating Full-Text Catalogs NOTE Full-text search SQL Server 2005 provides Full-Text Search as a separately installable component. You can find the option to install full-text functionality under the Database Engine node within the SQL Server 2005 Setup Wizard. If you specify default settings for installing the Database Engine Full-Text Search is selected and installed. Full-text indexing has its own service called Microsoft Full-Text Engine for SQL Server MSFTESQL for populating and managing .