What does the CEILING() function do?

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

(Continued from previous question...)

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.

(Continued on next question...)

Other Job Interview Questions

• Can you use a CASE statement in a WHERE clause?
• How many of these servers can you consolidate?
• What is the maximum number of instances of Analysis Services 2005 can be installed on a server?
• 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?
• Which query will return a list of the synonyms in your database?
• You are writing a new stored procedure to perform maintenance on your SQL Server 2005 databases that defragments the indexes in an online manner. What command should you use?
• What is the default type of XML data if you do not specify an arguement?
• What does REVERT do in SQL Server 2005?
• What does the Queue Reader Agent do in SQL Server 2005 replication?
• How can you determine which user is executing statements in Profiler?
• More...