SQL in the Wild

A discussion on SQL Server


Archive for the 'Indexes' Category

SQL University: Advanced Indexing – Indexing Strategies

• Friday, November 11th, 2011

Posted in Indexes, SQL Server, Syndication | 7 Comments »


SQL University: Advanced Indexing – Filtered Indexes

• Wednesday, November 9th, 2011

Posted in Indexes, SQL Server, Syndication | 2 Comments »


SQL University: Advanced indexing – Sorting and Grouping

• Monday, November 7th, 2011

Posted in Indexes, SQL Server, Syndication | 12 Comments »


Indexing for ORs

• Tuesday, May 3rd, 2011

Posted in Indexes, SQL Server, Syndication | 8 Comments »


Is a clustered index best for range queries?

• Tuesday, February 1st, 2011

Posted in Indexes, Performance, SQL Server, Syndication | 9 Comments »


One wide index or multiple narrow indexes?

• Tuesday, September 14th, 2010

Posted in Indexes, SQL Server, Syndication | 19 Comments »


Is a scan a bad thing?

• Wednesday, July 29th, 2009

Posted in Indexes, SQL Server | 11 Comments »


When is a seek actually a scan?

• Thursday, March 5th, 2009

Posted in Indexes, Performance, SQL Server, Syndication | 9 Comments »


All indexes are unique

• Monday, February 9th, 2009

Posted in Indexes, SQL Server, Syndication | 9 Comments »


Index columns, selectivity and inequality predicates

• Friday, February 6th, 2009

Posted in Indexes, SQL Server, Syndication | 10 Comments »


« Previous Entries
  •  Subscribe in a reader

    Copyright policy
  • Popular Posts
    • Catch-all queries
    • Deleting the transaction log
    • Execution plan operations - joins
    • On Counts
    • Exists vs IN
    • Index columns, selectivity and equality predicates
  • Categories
    • SQL Server
      • Admin
      • Corruption
      • Indexes
      • Internals
      • Execution Plans
      • Performance
      • T-SQL
    • Personal
      • Artificial Intelligence
      • Career
      • Roleplaying
    • Conferences
    • Community
    • General
    • Misc
    • Rants


  • Microsoft MVP

    SQLServerPedia award

    SQLServerPedia award


  • Now Reading

    View Full Library

    Reading (5)

    • Agent-Based Evolutionary Search (Adaptation, Learning, and Optimization)
      Agent-Based Evolutionary Search (Adaptation, Learning, and Optimization) by Ruhul A. Sarker, Tapabrata Ray
    • Lord of Emperors: Book Two of the Sarantine Mosaic
      Lord of Emperors: Book Two of the Sarantine Mosaic by Guy Gavriel Kay
    • Artificial Intelligence for Games, Second Edition
      Artificial Intelligence for Games, Second Edition by Ian Millington, John Funge
    • Dauntless (The Lost Fleet, Book 1)
      Dauntless (The Lost Fleet, Book 1) by Jack Campbell
    • The Day Watch
      The Day Watch by Sergei Lukyanenko, Vladimir Vasiliev

    Planned (14)


    • Dreamsongs: 2 by George R.R. Martin

    • Under Heaven by Guy Gavriel Kay

    • A Song for Arbonne by Guy Gavriel Kay

    • The Warlord of Mars: John Carter of Mars, Book Three by Edgar Rice Burroughs

    • The Pragmatic Programmer: From Journeyman to Master by Andrew Hunt

    Finished (163)


    • Physics of the Impossible: A Scientific Exploration into the World of Phasers, Force Fields, Telepor by Michio Kaku

    • Changes (Dresden Files, Book 12) by Jim Butcher

    • The Gods of Mars: John Carter of Mars, Book Two by Edgar Rice Burroughs

    • A Princess of Mars: John Carter of Mars: Book One by Edgar Rice Burroughs

    • The Heart of Valor: A Confederation Novel by Tanya Huff

    • Hexed (The Iron Druid Chronicles, Book Two) by Kevin Hearne
    Now Reading
    Redux

  • SQL in the Wild is proudly powered by WordPress and ChaoticSoul (by Bryan Veloso)