SQL Server
concepts with Sachin Agrawal.....
Total Pageviews
Existence of partition function for given value
SELECT ‘partition function exist for given value’
FROM sys.partition_functions
fn
INNER JOIN sys.partition_range_values val
ON fn.function_id = val.function_id
WHERE fn.name = '<partition function name>'
AND val.value = '<value>'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment