Index[A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] data consumption importing/exporting data BCP BULK INSERT statements disconnected techniques live updates OPENROWSET statements SSIS readings/resources Service Broker assembling components into services components of creating queues defining message type dialogues providing contract details data filtering, conditional filtering data heaps data marts data partitioning indexes joins performance, improvements to tables advantages of ALTER DATABASE statements asymmetric design CREATE PARTITION FUNCTION statements CREATE PARTITION SCHEME statements data storage indexes $PARTITION queries row/column access patterns strategies for symmetric design table size views 2nd data querying conditional data filtering full-text indexes SELECT statements GROUP BY clause HAVING clause ORDER BY clause TABLESAMPLE clause TOP clause WHERE clause tables combining columns filtering data grouping data joining listing contents of renaming columns returning top rows sampling stored data selecting null value rows trimming white space data storage, partitioned tables data types list of timestamp UDT xml XML schema collections data updates computed columns data from previous SQL Server releases filtered updates multiple records object schemas positioned updates single records transaction processing data warehouses Database column (Activity Monitor) Database Diagram tool Database event class (SQL Profiler) Database Properties dialog databases administrators, replication ALTER DATABASE statements assemblies backups appending as system databases differential extra backups full initializing headers integrity of master databases media sets, creating model databases msdb databases overwriting read-only secondary servers recovery models reliability of removing inactive log entries restoring data from rewinding tape tail-log transaction logs truncating logs unloading tape validating data warm backup secondary databases components of CREATE DATABASE statements Database Diagram tool database diagrams DTA indexing strategies analyzing existing indexes determining what not to index determining what to index fill factor indexed views maintaining indexes maintenance readings/resources SQL Server master databases 2nd mirroring model databases 2nd msdb databases, backups objects associated objects, viewing creating implementing proxies roles snapshots 2nd statistics synonyms sys.databases catalog view system databases, backups as tables triggers [See DDL triggers.] views aggregate data benefits of indexed partitioned standard warm copies datetime data type DBCC (Database Console Command) maintenance operations miscellaneous operations options of server maintenance SQL Server performance validation operations DBCC INDEXDEFRAG command DBMS (database management system), SQL Server installations DDL triggers deadlocks decimal data type DEFAULT option defragmenting indexes delegations DELETE statements deleting table data DELETE statements DENY statements escalating deletion privileges GRANT statements REVOKE statements TRUNCATE TABLE method tables, cascading actions DENY statements, data deletion privileges Deprecation event class (SQL Profiler) dialogues security Service Broker, creating in differential backups DIGEST authentication (SQL Server) DISABLE INDEX statements DISABLE TRIGGER statements DISABLED state (endpoints) disconnected techniques disk systems, SQL Server installations distributed partitioned view distributors, role in replication 2nd DML triggers Do Not Keep Any Existing PDS option (PDS) document returns (XML) drives, SQL Server installations DROP DATABASE statements, deleting database snapshots DROP EXISTING option DTA (Database Engine Tuning Advisor) 2nd Advanced Tuning Options section Partitioning Strategy to Employ section PDS dynamic management functions and views 2nd |