SQL Server Database Keys: PrimaryKey, NaturalKey, ForeignKey, UniqueKey, CandidateKey, AlternateKey, CompositeKey, SuperKey, SurrogateKey

Hi Guys, How are you doing? Many a times during interviews I notice that candidates know lots of things but they really hesitate while talking about “SQL Server Database Keys“. And even if they know about keys, they fail to provide proper answers with examples. So, today I would like to summarize few definitions which [...]

March 26, 2012 · bigator Khilitchandra Prajapati · bigator 3 Comments
bigator Tags: AlternateKey, CandidateKey, CompositeKey, Database, ForeignKey, NaturalKey, PrimaryKey, SQL Server, SuperKey, SurrogateKey, UniqueKey · Posted in: General, SQL Server

Browse Posts
May 2013

M T W T F S S

« Feb

1 2 3 4 5

6 7 8 9 10 11 12

13 14 15 16 17 18 19

20 21 22 23 24 25 26

27 28 29 30 31
Categories Basket
- Business Intelligence (32)
  - Visio (2)
- General (46)
  - E-Book (3)
  - Excel (2)
  - Free (8)
  - Funny (1)
  - Microsoft Connect (1)
  - Microsoft Event (5)
  - New Features (10)
  - Quick Fix (9)
  - Training (3)
  - VB Script (1)
  - Windows (2)
- Interview QA (51)
  - Quick Tips (24)
  - Script (5)
  - Suggestion (8)
  - Tutorial (33)
- SharePoint (4)
  - SharePoint List Adapter (1)
- SQL Azure (2)
- SQL Server (60)
  - Database Diagram (1)
  - Database Snapshot (1)
  - Dynamic Management Views (2)
  - File Stream (1)
  - File Tables (1)
  - T-SQL (8)
- SQL Server 2012 (17)
  - Virtualization (1)
- SQLServerPedia (4)
- SSAS (15)
  - Data Mining (3)
  - DMX (4)
  - MDX (6)
  - Pivot Table (4)
  - Power Pivot (1)
  - Query Tuning (2)
- SSIS (19)
  - Default Logging (1)
  - DTEXEC (2)
  - Merge Join (1)
  - XP_CmdShell (1)
- SSRS (14)
  - Report Builder 3.0 (1)
  - SparkLines (1)
- Uncategorized (4)
- Video (1)