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: table seek

SARGable expressions and performance

Understanding the concept of SARGable expressions can dramatically help you speed up query performance. Here’s how:

Continue reading SARGable expressions and performance
Published 2014-01-19
Categorized as Intermediate, SQL Server concepts, T-SQL Tagged function, index scan, index seek, performance, range, sarg, sargable, scalar, table scan, table seek, where
sqlsunday.com
Proudly powered by WordPress.