June 6, 2013 at 11:24 am
Hi all experts,
My question is my do we need Partition function?
What would have happen if microsoft would have not included Partition Function feature in SQL Server?
June 6, 2013 at 11:47 am
Shadab Shah (6/6/2013)
My question is my do we need Partition function?
To tell what rows go in what partition of a partitioned table
What would have happen if microsoft would have not included Partition Function feature in SQL Server?
We wouldn't have the partitioned table feature.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 19, 2013 at 4:40 pm
Partitioning is required to optimize the performance of SQL Server database. If database contains very large tables, you may benefit from partitioning those tables onto separate filegroups. This technology, introduced in SQL Server 2005, allows to spread data onto different physical disks, leveraging the concurrent performance of those disks to optimize query performance.
Partitioning a SQL Server database table is a three-step process and Create the partition function is the first step.
August 19, 2013 at 5:20 pm
Partitioning is not primarily for performance.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply