(Solved) : Find Row Size Student Table Space Required Entire Table Assuming 80 Fill Factor Estimate P Q44139816 . . .
Find row size for the student table and the space required forthe entire table. Assuming a 80% fill factor estimate primary datafiles. Ignore storage requirements for indexes , views andconstraints.
Expected step answers are
- Number of rows in a page
- total number of pages required for the table
- Total Table size in KB or MB
- Total file size in Kb or MB
The student table has following 3 columns.
Student Table:
Id BIGINT not null
Name NCHAR(20) not Null
Branch NVARCHAR (64) null
The table contains : 100000 rows .
Need steps to display work. Please I am not sure where to plugin the numbers when adding up
Expert Answer
Answer to Find row size for the student table and the space required for the entire table. Assuming a 80% fill factor estimate pri…
OR