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 scan

The compelling case for using heaps

I’m an outspoken advocate of always using a clustered index on each and every table you create as a matter of best practice. But even I will agree that there’s a case for using the odd heap now and then.

Continue reading The compelling case for using heaps
Published 2016-09-01
Categorized as Basics, Rant, Tips Tagged clustered index, delete, etl, heap, index, insert, order, performance, rid lookup, table scan, update

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.