In the scenario from Tables 4-4, 4-5, and 4-6, how much space does the Vendors table require?

In the scenario from Tables 4-4, 4-5, and 4-6, how much space does the Vendors table require?

In the scenario from Tables 4-4, 4-5, and 4-6, how much space does the Vendors table require?


Answer – 167 MB

(The three fixed-length columns added together are 4 + 2 + 9 = 15 bytes. The variable columns take up 2 + (3 × 2) + 50 = 58 bytes. The null bitmap is 2 + ((6 + 7) ÷ 8) = 3.625, or 3 bytes. The total row size is 15 + 58 + 3 + 4 = 80 bytes. Each page holds 8,096 ÷ (80 + 2) = 98 rows per page. The total number of pages in the database is 2,000,000 ÷ 98 = 20,408 pages. Each page is 8,192 bytes. Therefore, the table takes 170,663,936 bytes, or about 167 MB.)