The Sort component in SQL Server 2005 Integratio

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

(Continued from previous question...)

The Sort component in SQL Server 2005 Integration Services is what type of component?

Answer
Blocking Transformation

Explanation
The Sort component is a blocking transformation meaning that it needs all rows in order to perform its function.

(Continued on next question...)

Other Job Interview Questions

• Setting the TRUSTWORTHY database property to ON allows you to execute the following from within the context of the database: Submitted by Charles Hawkins
• What does this method in SQL Server 2005's SMO equate to in T-SQL? db.CheckTables(RepairType.None)
• Can you use Full-text search to index this column?
• Yesterday's QOD How are comments denoted in an XML document?
• What is the result of the following query?
• What does @@MAX_PRECISION return?
• When starting SQL Server 2005 from the command line, what does the -h switch do?
• What is an index? What types of indexes are available in SQL Server 2000?
• What does the SQL Writer service do?
• What does the Log Reader agent in SQL Server 2005 replication do?
• More...