What is a partition function?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is a partition function?
Rating:
A partition function maps the rows of a table or an index to partitions that are based on the values of a column. SQL Server 2005 places the rows in the left-most partition if their partitioning column has null values. The partition function is created using the CREATE PARTITION FUNCTION statement. This function is created before creating a partition scheme.
Rating:
Was this information helpful?
Other articles
- Service Broker
- What is a CLR function?
- What is database mirroring?
- What is alert?
- What is a unique index?