摘要： Lesson 1: Index ArchitectureQuick Check1. What type of structure does SQL Server use to construct an index?2. What are the three types of pages within an index?Quick Check Answers1. SQL Server uses a B-tree structure for indexes.2. An index can contain root, intermediate, and leaf pages. An index ha 阅读全文

摘要： CREATE TABLE[ database_name . [ schema_name ] . | schema_name . ] table_name( { | | }[ ] [ ,...n ] )[ ON { partition_scheme_name ( partition_column_name ) | filegroup| "default" } ][ { TEXTIMAGE_ON { filegroup | "default" } ][ FILESTREAM_ON { partition_scheme_name | filegroup| &q 阅读全文