What is a Page in MS SQL Server?

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

(Continued from previous question...)

What is a Page in MS SQL Server?

A Page in MS SQL Server is the smallest unit of storage managed by the server to store data objects.

(Continued on next question...)

Other Job Interview Questions

• What is the difference between a Default Instance and a Named Instance of MS SQL Server?
• What are distributed queries?
• What is a Stored Procedure in MS SQL Server?
• Does MS SQL Server support IPX/SPX?
• What is a simple way to detach a database that is not in use in MS SQL Server?
• What is the difference between a "User DSN" and a "System DSN" ODBC connection?
• What is a simple way to rename a database in MS SQL Server?
• What should you do to prepare for MS SQL Server upgrade?
• What is the fully qualified naming convention to specify a table in a linked Oracle database from MS SQL server?
• What is the meaning of the following T-SQL command: SELECT TOP 10 * FROM user WHERE last_name = 'Johnson'
• More...