What does VARP() do in SQL Server 2005?

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

(Continued from previous question...)

What does VARP() do in SQL Server 2005?

Answer: This function returns the statistical variance of the values in the column.
Explanation: This function returns a statistical variance for the population of values on which it is run.

(Continued on next question...)

Other Job Interview Questions

• What What does the term ACID refer to?
• Which framework would you use to manage this database programatically?
• In SQL Server 2005, which of the following schema changes are supported for the publication objects of a replicated database?
• What does a @@fetch_status of -2 mean in SQL Server 2005?
• What is a bookmark lookup?
• Where are Notification Services event messages logged in SQL Server 2005?
• What does the function ORIGINAL_LOGIN return in SQL Server 2005?
• You cannot remember what permissions that the db_accessadmin fixed database role has ...
• To optimize the configuration of tempdb for performance, what setting should be used for the tempdb recovery model?
• What is the Service Broker Identifier
• More...