(Continued from previous part...)

What message types exist in SQL Server 2005 Service Broker?

Answer
These are defined for each contract.
Explanation
Each application that sets up queues and contracts inside Service Broker must define the message types that are valid for the contract.

What does the CEILING() function do?

Answer
Returns the smallest integer greater than or equal to the value passed in.
Explanation
CEILING() returns the smallest integer that is great than or equal to the value passed in.

What is a dialog conversation in the SQL Server 2005 Service Broker.

Answer
A dialog conversation is a conversation between services.
Explanation
A dialog conversation is a conversation between services. A conversation includes messages being passed back and forth as part of a contract.

What is row versioning in SQL Server 2005?

Answer
Row versioning keeps a copy of each row for use by applications or transactions to prevent readers from being blocked by writers.
Explanation
Row versioning is a method whereby the database engine keeps a copy of a row's data as it existed before the start of a transaction for queries to read this data and reduce locking contention if they are configured.

What does @@MAX_PRECISION return?

Answer
The maximum precision for numeric and decimal data.
Explanation
This function returns the maximum precision for numeric and decimal data as set on the server. The default for SQL Server 2005 is 38.

(Continued on next part...)