Home
11.
What is the cost threshhold for parallelism in SQL Server 2005?

This is the number of seconds that a serialplan cannot exceed if it is to be used. A parallel plan is used if the estimate exceeds this value.

This is the threshold at which SQL Server determines whether a serial or parallel plan is to be used. When SQL Server calculates that a serial plan exceeds the threshold, it will elect to use a parallel plan instead.

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

Determines the number of partitions used in an index crawl. This option helps optimize the full-text indexing process by specifying the number of partitions the SQL Server uses during index crawls.

13.
How can SQL Server Agent Mail send messages in SQL Server 2005?

SQL Mail through Extended MAPI or Database mail.

SQL Server Agent Mail can be configured to use Database Mail or Extended MAPI.

14.
Which of the following statements best describes the filter capabilities of Report Builder?

Users can do equals, greater than, less than, etc, plus they can do logical AND, OR, NOT operations. Users can also group filters to allow more advanced filters. While it looks a little different than you may be used to, the filter builder is reasonably rich, allowing most standard evaluation types and rich boolean comparisons. The only weak spot in the set is no support for LIKE, you have to make do with CONTAINS.

15.
Using Report Builder, which of the following is the best statement about the formatting options for Boolean columns?

Booleans are formatted as True/False and there are no other built in options, but you could build an expression using IIF that would let you do other formatting From the format dialog there are no extra formatting options for Booleans, Report Builder renders them as True/False. Writing an expression that you add to the model view is the easiest way to work around this limitation.