By Rob Volk on 3 June 2002 | Tags: Database Design
Good introduction on general database theory and design. Lots of terminology defined, explained and...best of all...DEMONSTRATED!
Link: Database Design Concepts
Using SET NULL and SET DEFAULT with Foreign Key Constraints (12 August 2008)
Implementing Table Interfaces (19 May 2008)
Implementing Table Inheritance in SQL Server (20 February 2008)
The Daily Database Build (23 August 2004)
HOW TO: Move a Database Diagram (12 December 2003)
Database Design Thoughts for Packaged Applications (26 October 2003)
The current state of database research (16 September 2003)
Using Metadata (24 March 2003)
BATCH CTE and recursion - CTE table doesn't exists (80m)
Distinct Values (10d)
HOW To get result from delete a row then execute store proc (10d)
SUMIF scenario in SQL (11d)
Fill forward for YTD calculations (12d)
Script Every Operator (12d)
Inserting results of sp_WhoIsActive in a remote table on remote sql server machine (12d)
Cannot connect from SQL server from SSMS to Ms Access back end. (13d)
SQLTeam.com Articles via RSS
SQLTeam.com Weblog via RSS
- Advertisement -
Articles
Forums
Blogs
Contact Us
About the Site
