摘要： Lesson 1: Creating a Partition FunctionCREATE PARTITION FUNCTIONmypartfunction (int)AS RANGE LEFTFOR VALUES (10,20,30,40,50,60)Quick Check1. What data types cannot be used with partition functions?2. What is the maximum number of partitions allowed for a table?3. What is the maximum number of bounda 阅读全文

摘要： Lesson 1: Creating and Populating Full Text IndexesCREATE FULLTEXT CATALOG catalog_name[ON FILEGROUP filegroup ][IN PATH 'rootpath'][WITH ][AS DEFAULT][AUTHORIZATION owner_name ]::=ACCENT_SENSITIVITY = {ON|OFF}CREATE FULLTEXT INDEX ON table_name[ ( { column_name[ TYPE COLUMN type_column_name 阅读全文