The seven states participating in the learning collaborative, which is supported by the Lucile Packard Foundation for Childrenâs Health, are Delaware, Georgia, Massachusetts, Nevada, New Mexico, Rhode Island, and West Virginia.
You can create a partitioned table or index in SQL Server 2016 by using SQL Server Management Studio or Transact-SQL. The data in partitioned tables and indexes is horizontally divided into units that can be spread across more than one filegroup in a database.
SQL Server 2008 R2. The topics in this section provide the information to help you understand the concepts of partitioned tables and indexes and the reasons for implementing partitioning, and an overview of how partitioned tables and indexes are implemented in the AdventureWorks2008R2 sample database.