In SQL Server 2005, you want to monitor your tra

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

(Continued from previous question...)

In SQL Server 2005, you want to monitor your transactional replication and determine how long it takes for a transaction to move from the publisher to a subscriber. What would you use to help you do this?

Answer
Tracer Tokens.

Explanation
You can use tracer tokens in SQL Server 2005 replication to measure latencies. These are small amounts of data written into your transaction logs.

(Continued on next question...)

Other Job Interview Questions

• Can you use a CASE statement in a WHERE clause?
• How many rows are returned by these two select statements?
• How can SQL Server Agent Mail send messages in SQL Server 2005?
• You have upgraded your SQL Server 2000 on Windows 2000 server to SQL Server 2005 to take advantage ...
• What does the CEILING() function do?
• If you use the EXECUTE AS clause to impersonate a user at a database-scoped level...
• What is the timestamp datatype used for?
• Can a deterministic computed column be full-text indexed in SQL Server 2005? Submitted by Matija Lah
• When a user on a remote SQL Server wants to execute a stored procedure through a linked server on your local server, what security context is used?
• How many dimensions can you have in a SQL Server 2005 Analysis Services database?
• More...