SQL Server 2016

Intervals

Various Topics

T-SQL

Set Theory

Relational Model

SQL

  • 3604, 3605: Direct the output of some DBCC commands to the client or the error log, respectively
  • 9481, 2312: Legacy (7.0) and new (2014) cardinality estimators, respectively
  • 4137: use most selective estimate (only works with legacy CE 7.0)
  • 9471: use most selective estimate (with new CE 120)
  • 9472: use independence assumption
  • 2389: Ascending keys and auto quick corrected statistics
  • 2371: Dynamic auto update statistics threshold
  • 652: Disable read ahead
  • 8744: Disable Nested Loops prefetch
  • 8649: Parallel query plan
  • 3917: Get information about eager writes behavior (requires 3604 or 3605 for output)
  • 2453: Triggers recompiles for table variables based on thresholds like for other tables
  • 272: Disables caching for identity in SQL Server 2012 and later
  • 9453: Disable batch mode processing