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: order

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

Know your collation orders

We’ve discussed earlier on the effect of using SQL wildcards, such as ‘%[a-z]%’ with different collation orders, particularly case sensitive ones. Here’s another take on collations, and how different collation orders can sort text differently.

Continue reading Know your collation orders
Published 2013-05-19
Categorized as Intermediate, T-SQL, Tips Tagged collation, cte, language, maxrecursion, order, recursion, sort, sort order
sqlsunday.com
Proudly powered by WordPress.