Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Partitions

    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

  • RE: Partitions

    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

  • RE: Partitions

    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...

Viewing 3 posts - 1 through 3 (of 3 total)