摘要：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 阅读全文

摘要：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 阅读全文

摘要：http://msdn.microsoft.com/en-us/library/cc262957%28v=office.12%29.aspx指针：#pragma once#include <stdio.h>int main(void){ int stopFlag = 0; int a; int *aPtr; a = 7; aPtr = &a; printf("The address of a is %p\nThe value of aPtr is %p", &a, aPtr); printf("\nThe value of a is % 阅读全文