NAIMMCQ MS SQL Server 2008 Using the data from Table 6-5, you need to partition the table into three divisions, one for employees who make less than $50,000, one for employees who make $50,001 to $70,000, and one for employees who make $70,001 and higher. Which function should you use?

Using the data from Table 6-5, you need to partition the table into three divisions, one for employees who make less than $50,000, one for employees who make $50,001 to $70,000, and one for employees who make $70,001 and higher. Which function should you use?

MS SQL Server 2008

Using the data from Table 6-5, you need to partition the table into three divisions, one for employees who make less than $50,000, one for employees who make $50,001 to $70,000, and one for employees who make $70,001 and higher. Which function should you use?

Answer – CREATE PARTITION FUNCTION pfSalary (money) AS RANGE LEFT FOR VALUES (50000,70000);

(The LEFT range gives you three partitions: 0–50,000, 50,001–70,000, and 70,001 and higher. A RIGHT range would give you 0–49,999, 50,000–69,999, and 70,000 and higher.)

NAIMMCQ

Using the data from Table 6-5, you need to partition the table into three divisions, one for employees who make less than $50,000, one for employees who make $50,001 to $70,000, and one for employees who make $70,001 and higher. Which function should you use?

Using the data from Table 6-5, you need to partition the table into three divisions, one for employees who make less than $50,000, one for employees who make $50,001 to $70,000, and one for employees who make $70,001 and higher. Which function should you use?

Share this