SQL Server - AtanuMandal/.net-check-list GitHub Wiki

Indexing and Keys

  • clustered Index
  • Non clustered Index
  • Primary key
  • Filtered Index
  • Candidate Key
  • Alternate Key
  • Composite Key

Table

  • statistics
  • Temp table (global/local), table variable, common table expression (CTE)
  • Heap / Clustered table
  • Magic tables

Query

  • Execution Plan
  • Table scan, index scan, index seek
  • Join vs sub query
  • Inner join, outer join, cross join

Locks

  • shared , exclusive, update lock
  • isolation levels
  • read uncommited
  • read committed
  • repeatable read
  • Serializable

Misc.

  • Commit/Rollback/Transaction

  • Normalization

  • De-normalization and when to use?

  • sparse column

  • ACID properties