What does @@textsize return?

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

(Continued from previous question...)

What does @@textsize return?

Answer
The current value of the TEXTSIZE option for the SET command.
Explanation
This returns the current value of the TEXTSIZE option that can be changed with the SET command. The default is 4096 bytes.

(Continued on next question...)

Other Job Interview Questions

• Which of the following is not true about the Raw File Destintion connection in SQL Server 2005 Integration Services?
• What does this method in SQL Server 2005's SMO equate to in T-SQL? db.CheckTables(RepairType.None)
• What does SEND do in SQL Server 2005?
• In SQL Server 2005 Full-Text Search, you set up a replacement set like this...
• You need to remove a large table from your database ...
• To optimize the configuration of tempdb for performance, what setting should be used for the tempdb recovery model?
• Which database holds the tables that Database Mail uses to store mail messages and other data in SQL Server 2005?
• What does the CREATE SERVICE statement do in SQL Server 2005?
• Can you use a CASE statement in a WHERE clause?
• What result would you expect from this statement? Select * from dbo .MyTable
• More...