What does the max full-text crawl range option d

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What does the max full-text crawl range option do?

Answer
Determines the number of partitions used in an index crawl.

Explanation
This option helps optimize the full-text indexing process by specifying the number of partitions the SQL Server uses during index crawls.

(Continued on next question...)

Other Job Interview Questions

• What does the ERROR_PROCEDURE() function return?
• What is the scope of the control permission in SQL Server 2005?
• You are using SQL Server 2005 and you wish to find a number of details about stored procedures created...
• Which permission in SQL Server 2005 allows you to switch your security context to that of another user with the EXECUTE AS statement?
• If you absolutely need a report to look the same regardless of what OS or viewing software is being used, which of the following file formats would be the best choice?
• What does a report model provide in SQL Server 2005 Reporting Services?
• What does this return? select (1324 & 1024)
• You want to script the execution of an Integration Services package from the command line for use from a Unix scheduler. What utility would you use?
• If you have a replication scenario with one publisher, one distributor and one subscriber and the transaction isolation level is not set to serializable, what happens when a transaction fails on the publisher?
• You are performing a number of SELECT queries on one of your SQL Server 2005 Service Broker queues and you get a call that applications using the queues are running slowly. What can you do?
• More...