Mike Beaver's Tech Support Page 3

SQL By Design: The Foreign Key Identity and Primary Keys - Part I SQL by Design: How to Choose a Primary Key Creating and Modifying PRIMARY KEY Constraints	How Surrogate Primary Key Generation Affects Concurrency and the Cache Hit Ratio "The Case for the Surrogate Key", choosing Primary Keys discussion thread in comp.databases.ms-access
Views and Stored Procedures
CREATE VIEW Creating an Indexed View Creating a Partitioned View Views and Stored Procedures	Programming Stored Procedures Writing a Stored Procedure Resolving Distributed Partitioned Views Modifying Data Through a View
Triggers
The Trouble with Triggers, Part I, Part II, Part III Triggers Viewing a Trigger CREATE TRIGGER ALTER TRIGGER Programming Triggers	Using Columns_Updated() in a Trigger Proper Use of the COLUMNS_UPDATED() Function Use COLUMNS_UPDATED Chapter 37 - Extending Triggers with INSTEAD OF Identifying Modified Columns Puzzle
Normalization
An Introduction to Database Normalization SQL by Design: Why You Need Database Normalization Normalization	Database Normalization Database Normalization And Design Techniques A Simple Guide to Five Normal Forms in Relational Database Theory
Links Pages
MS SQL Server 2000 Database Journal.com's: links SQL Server Links	San Diego User Group's: Links SQL Reference Page Pal's Linux RDBMS Library
User Groups
Baltimore SQL Server Users Group Calgary SQL Server Users' Group Capital Area SQL Server User Group "CinSSug" Cincinnati SQL Server Users Group Connecticut SQL Server User Group Edmonton SQL Server User Group Heartland Users Groups (HUG) SQL Server SIG Indian SQL Server Professionals - User Group Microsoft Access/SQL Server/ASP User Group Nashville SQL Server User Group New England SQL Server Users Group New Jersey/Update New York SQL Server Users Group Norfolk SQL Server Users Group	Pacific NW SQL Server Users Group PASS (Professional Association for SQL Server) Philadelphia Enterprise Developer User Group Pittsburgh SQL Server Users Group Reluctant DBAs Rocky Mountain SQL Server Users Group San Diego User Group St. Louis SQL Server Users Group SQL Server Worldwide Users Group Sydney .NET Users Group Tampa Bay SQL Server Users Group Toronto SQL Server Users Group U.K. SQL Server User Group
News Groups (Google Groups / formerly DejaNews)
microsoft.public.sqlserver.ce microsoft.public.sqlserver.connect microsoft.public.sqlserver.datawarehouse microsoft.public.sqlserver.dts microsoft.public.sqlserver.olap microsoft.public.sqlserver.programming	microsoft.public.sqlserver.security microsoft.public.sqlserver.server microsoft.public.sqlserver.setup microsoft.public.sqlserver.tools SQL Server Central's: E-Mail Discussion Lists
Back to Mike Beaver's Hypnotherapy Home Page