You have a large table that you wish to partitio

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

(Continued from previous question...)

You have a large table that you wish to partition to improve performance...

You have a large table that you wish to partition to improve performance. The table contains many columns of data about customers and you decide that basic information about each customer will remain in the current table. Extended information, such as shipping instructions, secretaries' names, etc. will be moved to a new table along with the PK. What type of partitioning is this?

Answer
Vertical partitioning

Explanation
If you are moving some columns from one table to a new table, this is vertical partitioning.

(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?
• Which of the following services is instance-aware?
• How are modified extents tracked in SQL Server 2005 (which internal structures)?
• Which key does the OPEN MASTER KEY statement open?
• You want to be sure your database server if properly secured. You have two instances, a default instance and a named instance installed. Which ports do you need to open?
• You are building a .NET assembly that will access the registry of the local machine for a factor used in a computer column. What permission set should you assign it?
• What is a bookmark lookup?
• What does the NULLIF function do?
• Can you use Full-text search to index this column?
• Out of the box Report Builder supports two report level fields that can be shown on a report. Which option below has those two options?
• More...