Design and Implementation 1 Client operating systems 1 Management tools 1 System Tables 2 Database catalog 2 System catalog 2 Implementing a SQL database 2 Database Maintenance 3 Design and Implementation 3 Data Control Language Statements 3 SQL Server Object Names 4 Denotes 4 Delimiters 5 Guidelines for naming database objects 5 Global Variables 6 Operators 6 Most common types of operators 7 OPERATOR PRECEDENCE LEVELS 8 TYPE 8 Functions 8 Date and Time Functions 9 Mathematical Functions 10 Metadata Functions 10 Security Functions 10 String Functions 10 System Functions 10 In-line Comments 12 Block Comments 12 Dynamically Constructing Statements 13 Considerations for using the EXECUTE statement 13 Cached queries 14 Design and Implementation 15 Data Control Language Statements 15 SQL Server Object Names 16 Denotes 16 Delimiters 17 Guidelines for naming database objects 17 Global Variables 18 Operators 18 Most common types of operators 19 OPERATOR PRECEDENCE LEVELS 20 TYPE 20 Functions 20 Date and Time Functions 21 Mathematical Functions 22 Metadata Functions 22 Security Functions 22 String Functions 22 System Functions 22 In-line Comments 24 Block Comments 24 Dynamically Constructing Statements 25 Considerations for using the EXECUTE statement 25 Cached queries 26 SQL DB Design part 2A 27 Developing a Logical Data Model 27 When to Denormalize 28 Types of Data Integrity 28 Enforcing Data Integrity 29 Constraint Overview 30 Planning and Creating Indexes 31 How Data Is Stored 31 How Data is Accessed 32 When to create indexes 33 Indexing columns 33 Clustered Indexes 34 Accessing data using a clustered index 35 Nonclustered indexes 36 Nonclustered indexes 36 Accessing data in a heap 36 Accessing a Range of Data 37 Accessing data with clustering keys 37 Before creating an index, ask the following 38 Unique indexes 39 USE library 39 Guidelines for creating a Unique Index 39...
International Bibliography of Periodical Literatur...
database
Microsoft SQL Server Management Studio displaying ...