Partitioning is to create our very large tables or indexes in separate segments.
In other words, when we convert the large table or indexes that appear logically as a whole into a Partitioned structure, we can divide them into smaller physical parts.
SQL Server table Partitioning has a great contribution to performance. So If there are tables and columns which are appropriate for Partitioning, they should make partitioned.
You can check if table is partitioned in SQL Server with following query.
select distinct pp.[object_id], TbName = OBJECT_NAME(pp.[object_id]), index_name = i.[name], index_type_desc = i.type_desc, partition_scheme = ps.[name], data_space_id = ps.data_space_id, function_name = pf.[name], function_id = ps.function_id from sys.partitions pp inner join sys.indexes i on pp.[object_id] = i.[object_id] and pp.index_id = i.index_id inner join sys.data_spaces ds on i.data_space_id = ds.data_space_id inner join sys.partition_schemes ps on ds.data_space_id = ps.data_space_id inner JOIN sys.partition_functions pf on ps.function_id = pf.function_id order by TbName, index_name ;
Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.
1,683 views last month, 2 views today
I must thank you for the efforts you’ve put in penning this website. I am hoping to see the same high-grade content from you in the future as well. In truth, your creative writing abilities has inspired me to get my very own blog now ;)|