There is no clustered index on the table and I need to create one, will fill factor 0.
How will this impact space utilization on disk? What about white space in the datafile?
1)
clustered index is physically sorting of data and sql server need extra space (1.2 times the space required for the entire table) to physically sort the data and create index.
you can use the option sort_in_temdb but better first understand about pros/cons of this option in BOL.
2)
not able to understand what do you mean by What about white space in the datafile?
----------
Ashish