SQL server standards

SQL server standards - Development and programming standards. (pdf 30 pages)

SQL server standards - Development and programming standards. (htm 30 pages)

Table of contents
1 Overview
- 1.1 Subject
- 1.2 Summary
- 1.3 History & author
- 1.4 Audience
- 1.5 Limitations
- 1.6 Acronyms
- 1.7 Glossary
2 Why bother with SQL Server development standards?
3 Introduction to stored procedures
- 3.1 Scalibility
- 3.2 General guidelines
- 3.2.1 Use an agreed naming convention
- 3.2.2 Avoid using SQL reserverd words.
- 3.2.3 Use the agreed standard abbreviations
- 3.2.4 Use agreed standard customer / company abbreviations
- 3.2.5 Undocumented functionality
- 3.2.6 ANSI join syntax
- 3.2.7 Avoid TSQL in C++/ASP
- 3.2.8 Constants
4 Naming conventions
- 4.1 Stored procedure name
- 4.1.1 General naming guidelines
- 4.1.2 COMPANY related sp naming:
- 4.2 Table names
- 4.2.1 Modules of tables
- 4.3 Columns
- 4.4 Index names
- 4.5 Foreign keys
- 4.6 Check contraints
- 4.7 Defaults
- 4.8 Rules
- 4.9 Triggers
- 4.10 User defined datatypes
- 4.11 Views
- 4.12 Variable name
- 4.12.1 Datatype
- 4.12.2 Scope
- 4.12.3 Parameters
- 4.13 Naming convention disadvantages
5 COMPANY abbreviations for DB object names
- 5.1 General word abbreviations
6 COMPANY specific column names
7 Comments
- 7.1 Procedure header
- 7.2 Debug comments
8 Indentation
9 SQL performance tuning
- 9.1 Performance measurement tools
- 9.1.1 Query analyser
- 9.1.2 SET STATISTICS
- 9.1.3 Performance monitor
- 9.1.4 Profiler / trace
- 9.2 Indexes
- 9.2.1 Column selection
- 9.2.2 Clustered & non-clustered indexes
- 9.2.3 Covered queries
- 9.2.4 Selectivity
- 9.2.5 Index resource overhead
- 9.2.6 Index hints
- 9.3 Select statement
- 9.3.1 SELECT *
- 9.4 Table Joins
- 9.5 Transactions (txns)
- 9.6 Locking
- 9.6.1 (NOLOCK)
- 9.6.2 TRANSACTION ISOLATION LEVEL
- 9.6.3 Row-level locking
- 9.7 Qualify names
- 9.8 NULLS
10 Reliability & resilience
- 10.1 INSERT
- 10.2 Check values
11 SQL traps & bugs
- 11.1 IN() & NOT IN()
- 11.2 SET & SELECT
12 IDENTITY columns
- 12.1 Warnings
- 12.2 Drawbacks
- 12.3 Unique ID generator
- 12.4 SET IDENTITY_INSERT
13 SET
- 13.1 LANGUAGE
- 13.2 DATEFORMAT
- 13.3 NOCOUNT
- 13.4 ROWCOUNT
14 Data dictionary
- 14.1 What is a data dictionary?
- 14.2 Why have a data dictionary?
- 14.3 Implementation
- 14.4 Data stored
15 Entity Relationship Diagrams (ERD)
15.1 Why use ERDs?
15.2 Terminology
15.3 Relationships
15.3.1 Number of enities in a relationship
15.3.2 Optionality
15.3.3 Cardinality
15.3.4 Exclusive relationships
15.4 Notation
15.4.1 VISIO Notation
16 References

Page search phrases:

Microsoft SQL server standard, Microsoft SQL server standards, Microsoft SQL server proframing standards, Microsoft SQL server development standards, Microsoft SQL server coding standards, Microsoft SQL server dba standards, Microsoft SQL server conventions.