Database
Normal Forms
Normal Forms
- A Simple Guide to Five Normal Forms in Relational Database Theory (link)
Clustered vs Non-Clustered Index
Clustered vs Non-Clustered Index
Joins
Joins
Outer Join
Outer Join
- Using Outer Joins (link), MSDN
Relational Databases
Relational Databases
SQLite
SQLite
SQL Server
SQL Server
To delete records from the table and also reset the Identity field, use
truncate table [schema].[Table]
SQL Server list of updates (link). Lists service packs and any cumulative patches released.
SQL Compact
SQL Compact
SQL Compact is Microsoft's parallel to SQLite. It is a small database engine that can be used both on desktop and on mobile devices.
Utilities
Utilities
See Database Tools page for tools.