Skip to content

sqlsunday.com

  • About
  • Structured Concepts
    • Master data tool
    • OAuth wizard
    • Send passwords
  • Presentations
  • Downloads
  • Checklists
    • Installing SQL Server 2014
    • Installing SQL Server 2016
    • Installing SQL Server 2017
    • Installing SQL Server 2019
    • Installing SQL Server 2022
    • Conference organizer tools
    • Conference organizer checklist

Tag: not in

Nullable columns and performance

We need to talk about the nullable columns in your database. Specifically, because of how NULL values are compared, they can dramatically affect how some lookup operations perform.

Continue reading Nullable columns and performance
Published 2019-01-03
Categorized as Intermediate, T-SQL Tagged except, in, intersect, not in, null, nullable, performance, row count spool
sqlsunday.com
Proudly powered by WordPress.