Normal Forms- A Simple Guide to Five Normal Forms in Relational Database Theory (link)
Clustered vs Non-Clustered Index- What is the difference between clustered and nonclustered indexes? (link)
- Clustered index vs. non-clustered index (link)
- An Introduction to Clustered and Non-Clustered Index Data Structures (link)
JoinsOuter Join- Using Outer Joins (link), MSDN
Relational DatabasesSQLiteSQL ServerTo 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 CompactSQL 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 |