随笔分类 -  SQL Server 2008读书笔记

摘要：#1：将一列的值设置另一列（相同表或者不同表）相同表：update Table1set Table1.Column1 = Table1.Column2 from Table1不同表：UPDATE Table1SET Table1.Column1 = Table2.Column2 FROM Table... 阅读全文

摘要：Lesson 1: Backing up DatabasesFull BackupsBACKUP DATABASE { database_name | @database_name_var }TO [ ,...n ][ ] [ next-mirror-to ][ WITH { DIFFERENTIAL | [ ,...n ] } ]::= { { logical_device_name | @logical_device_name_var }| { DISK | TAPE } ={ 'physical_device_name' | @physical_device_name_v 阅读全文

摘要：Lesson 1: Designing PoliciesQuick Check1. What are the fi ve objects that are used within Policy Based Management?2. What are the allowed execution modes for a policy?3. Which object has a property that allows you to mandate checking for all databases on an instance?4. How many facets can be checked 阅读全文

摘要：Lesson 1: Importing and Exporting Databcp {[[database_name.][owner].]{table_name | view_name} | "query"}{in | out | queryout | format} data_file[-mmax_errors] [-fformat_file] [-x] [-eerr_file][-Ffirst_row] [-Llast_row] [-bbatch_size][-n] [-c] [-w] [-N] [-V (60 | 65 | 70 | 80)] [-6][-q] [-C 阅读全文

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

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

摘要：Quick Check1. What are the types of fi les that you create for databases and what are the2. What is the purpose of the transaction log?Quick Check Answers1. You can create data and log fi les for a database. Data fi les commonly have either2. The transaction log records every change that occurs with 阅读全文

摘要：Quick Check1.Which edition of SQL Server supports installing more than one instance of SQL2. What are the authentication modes that SQL Server can be confi gured with?Quick Check Answers1. Only SQL Server Enterprise supports multiple instances on the same machine.2. You can confi gure SQL Server to 阅读全文