August 18, 2009 at 1:13 am
I’m a SQL Server newbie and currently I’m trying to document the Partition information, i.e., partitions available, the objects residing in the partitions along with the partition data size for a SQL Server 2005 environment.
I have looked at the available tables and DMVs(sys.partition_functions, sys.partition_parameters, .partition_range_values, sys.partition_schemes, sys.partitions, sys.dm_db_partition_stats) but this are not providing the information I require.
Request you to let me know how I can achieve this.
August 18, 2009 at 1:30 am
Hi Shankar,
What you mean by partition in SQL Server?
If u create a database you can specify the initial size ,growth and where the data and log file to reside.
you can check the files of database using
select * from sysfiles
August 18, 2009 at 2:23 am
Table partitions
August 19, 2009 at 10:39 pm
You can create different file groups and files inside that and can specify the tables to be created under particular filegroup
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply