What is the size 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 the size a Page in MS SQL Server?

The size of a Page is 8 KB. A Page is the minimum storage unit managed by MS SQL Server.

(Continued on next question...)

Other Job Interview Questions

• What does RDBMS stand for?
• If you finish installing MS SQL Server as Named Instance, what would be the default path name on the hard disk where the server will be installed to?
• What is the main purpose of assigning a user with the "processadmin" role?
• Does MS SQL Server support IPX/SPX?
• What is "bcp"?
• What is the main purpose of assigning a user with the "processadmin" role?
• What is the difference between a Default Instance and a Named Instance of MS SQL Server?
• What is the main feature of the "RAID 0" disk configuration?
• What is the different between concurrent connections and concurrent user logins?
• What is the difference between a Default Instance and a Named Instance of MS SQL Server?
• More...