This appendix provides samples of query scripts that can be used to store operation monitoring histories when using data partitions, which is a functionality of Microsoft SQL Server 2012, Microsoft SQL Server 2008 and Microsoft SQL Server 2005.

Note that these samples were created using the following assumptions.

• The storage destination is the JP1/Software Distribution installation target directory \SAMPLE\MSSQL.
• The database name specified is NETMDM_SAMPLE.
• The query scripts conform to the syntax in Microsoft's Transact-SQL reference.
  For details about this syntax, see Microsoft's Transact-SQL Reference.
  

Organization of this section

F.1 DropTable.sql query script

F.2 AddFilegroup.sql query script

F.3 AddFiletoEdrive.sql query script

F.4 AddFiletoFdrive.sql query script

F.5 CreatePartition.sql query script

F.6 CreateTable.sql query script

F.7 AddFilegroup2nd.sql query script

F.8 AddFiletoGdrive.sql query script

F.9 AlterPartition.sql query script

F.10 CreateArchTable.sql query script

F.11 SwitchPartition.sql query script

F.12 DropArchTable.sql query script

F.13 MergeRange.sql query script

F.14 AlterPartition2nd.sql query script

F.15 LargeAddFilegroup.sql query script

F.16 LargeAddFile.sql query script

F.17 LargeCreatePartition.sql query script

F.18 LargeAddFilegroup2nd.sql query script

F.19 LargeAddFiletoKdrive.sql query script

F.20 LargeAlterPartition.sql query script

F.21 LargeSwitchPartition.sql query script

F.22 LargeMergeRange.sql query script

F.23 LargeAlterPartition2nd.sql query script