sql server portal
sql server portal
sql server directorysql server software
 
sql server directorysql server portalsql server info
   

SQL server standards

sql server software
sql server faqs
 
 
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.