|
Related Questions |
View Answer |
|
Out of the box Report Builder supports two report level fields that can be shown on a report. Which has those two options?
|
View Answer
|
|
You have noticed in both your SQL Server 2000 and 2005 instances that when a database grows in SQL Server, there is a delay in the database response. Why is that?
|
View Answer
|
|
Using Reporting Services 2005, it is true or false that subreports execute a query against the datasource once for every detail row in the report?
|
View Answer
|
|
What choices show the three report formats supported by Report Builder ?
|
View Answer
|
|
What is the easiest way to capture the SQL statement for a Report Builder report you're troubleshooting?
|
View Answer
|
|
What is the formatting options for Boolean columns on report builder?
|
View Answer
|
|
What is image support in Report Builder?
|
View Answer
|
|
Using Report Builder that is bundled with Reporting Services 2005, which of the following would work as a way to add a derived field to a report?
|
View Answer
|
|
How can SQL Server Agent Mail send messages in SQL Server 2005?
|
View Answer
|
|
Which of the following is the best use for a Scalable Shared Database in SQL Server 2005?
|
View Answer
|
|
Which of the following is not an allocation unit in SQL Server 2005?
|
View Answer
|
|
You have two Service Broker instances running. One is on SQL1 with the default collation and the other is on SQL2 setup for French collation. Which collation is used for Service Broker messages sent between the instances?
|
View Answer
|
|
You have a Scalable Shared Database setup for reporting purposes on SQL2. You want to be able to keep a point in time view of the reporting database each month. What can you do?
|
View Answer
|
|
What is the cost threshhold for parallelism in SQL Server 2005?
|
View Answer
|
|
What does a @@fetch_status of -2 mean in SQL Server 2005?
|
View Answer
|
|
What does the Log Reader agent in SQL Server 2005 replication do?
|
View Answer
|
|
What is the Service Broker Identifier ?
|
View Answer
|
|
Where does Profiler store its temporary data in SQL Server 2005?
|
View Answer
|
|
If you received a "Performance Critical" status in the SQL Server 2005 replication monitor, what does this mean?
|
View Answer
|
|
The Sort component in SQL Server 2005 Integration Services is what type of component?
|
View Answer
|