Viewing 3 posts - 1 through 3 (of 3 total)
Regarding your second question, if it refers to partitioned views then the range etc. would be in the definition of the view. That is: sp_helptext nameofview
September 1, 2011 at 4:32 pm
#1376220
This will tell you the ranges in your partitions:
SELECT a.NAME, a.boundary_value_on_right, b.boundary_id, b.value
FROM sys.partition_functions a
INNER JOIN sys.partition_range_values b ON a.function_id = b.function_id
ORDER BY a.name
September 1, 2011 at 4:27 pm
#1376218
I am new to partitions but this may be a start:
SELECT b.NAME, a.*
FROM sys.partitions a
INNER JOIN sys.sysobjects b ON a.object_id = b.id
WHERE b.xtype = 'u'
ORDER BY...
September 1, 2011 at 4:23 pm
#1376216