|
Related Questions |
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
|
|
What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL?
|
View Answer
|
|
What does the Queue Reader Agent do in SQL Server 2005 replication?
|
View Answer
|
|
How does a differential backup know which extents have changed so that it can be very quickly run?
|
View Answer
|