Calculating required space for making object partitioned

microsoft.public.sqlserver.tools

5 Jun 2006 4:02 PM

Alexander Abdoullaev

Hello!

How can I calculate the space required in each filegroup from partition
scheme to make some table or index partitioned ?

For example, I have table1. The size of this table is 500 KB. Also I have
partition scheme PS1 maps on two filegroups PRIMARY, SECONDARY and partition
function which determines two partitions PF1 with boundary 5. If I will
making table partitioned, 250 KB will be store on PRIMARY filegroup and
other 250 KB on SECONDARY filegroup. I need to calculate space required in
PRIMARY and in SECONDARY for making table partitioned.

Could you help me, please ?

Thanks, Alexander