In what situation you should the "sp_showfilegro

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

(Continued from previous question...)

In what situation you should the "sp_showfilegroup" stored procedure?

If you want to know how many filegroups used by the database, you can use the "sp_showfilegroup" T-SQL stored procedure.

(Continued on next question...)

Other Job Interview Questions

• What is the meaning of an Inner Join operatin of two tables?
• What is setup.iss file used for during MS SQL Server installation?
• What is the meaning of the following T-SQL command: CREATE TABLE orders ...
• In what situation you should the "sp_showfilegroup" stored procedure?
• Can MS SQL Server be used for transation processing as well as data warehousing database?
• What is a Page in MS SQL Server?
• What two categories you can divide T-SQL statements into?
• What is the main feature of the "RAID 0" disk configuration?
• What is the meaning of the following T-SQL command: SELECT TOP 10 * FROM user WHERE last_name = 'Johnson'
• What is a Page in MS SQL Server?
• More...