What does this return on SQL Server 2005? sele

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

(Continued from previous question...)

What does this return on SQL Server 2005?
select NEWSEQUENTIALID()

Answer: This returns an error.

Explanation: This returns an error. The NEWSEQUENTIALID() function can only be used in a default constraint on a table, not in a query. When used there it returns a new GUID that is greater in value than any previously generated GUIDs.

(Continued on next question...)

Other Job Interview Questions

• You have a large table that you wish to partition to improve performance...
• You cannot execute procedures on the 2005 server. Why not?
• What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL?
• What is a performance consideration of having too many indexes on a production online transaction processing (OLTP) table?
• You are configuring a SQL Server 2005 Reporting Services instance for email delivery of reports. What are your options for delivering email?
• What does this return on SQL Server 2005? select NEWSEQUENTIALID()
• You restart your SQL Server on a Sunday morning after some maintenance ...
• You wish to prevent anyone from using the sa account on your SQL Server 2005 instance, but still keep it available if your polocy changes. What can you do?
• In SQL Server 2005 Analysis Services, what does the Synchronize Database Wizard allow you to do?
• This administrator will own the jobs. Which role should you assign?
• More...