You have a server that runs SQL Server 2008. The server supports an online application. New products are constantly being added to a database stored on the server. You identify the following:

Searches often take too long

Users cannot search by using multiple criteria

Users cannot adequately search product descriptions

Most queries that search the product descriptions use "LIKE *%...%"'

as the filter predicate You need to recommend a search process that meets the following requirements:

Reduces the amount of time it takes to return search results

Enables users to filter searches by using multiple criteria

Enables users to search product descriptions

Minimizes administrative effort

Minimizes development costs

What should you do?

Question

You have a server that runs SQL Server 2008. The server supports an online application. New products are constantly being added to a database stored on the server. You identify the following:

Searches often take too long
Users cannot search by using multiple criteria
Users cannot adequately search product descriptions
Most queries that search the product descriptions use "LIKE *%...%"'

as the filter predicate You need to recommend a search process that meets the following requirements:

Reduces the amount of time it takes to return search results
Enables users to filter searches by using multiple criteria
Enables users to search product descriptions
Minimizes administrative effort
Minimizes development costs

What should you do?

Accepted Answer

D. Implement Full-Text Search.

Answer

A. Create a stoplist that contains the product descriptions.

Answer

B. Create a nonclustered index and include the product description.

Answer

C. Create filtered indexes on the product description.

You have a server that runs SQL Server 2008. The server supports an online application. New products are constantly being added to a database stored on the server. You identify the following…

Question

Options

How the community answered

Community Discussion