MSSQL Server Indexing Myths


  1. SQL Server Index Myth 1 : Databases Don’t Need Indexes
  2. SQL Server Index Myth 2: Primary Keys Are Always Clustered
  3. SQL Server Index Myth 3: Online Index Operations Don’t Block
  4. SQL Server Index Myth 4: Any Column Can Be Filtered in Multicolumn Indexes
  5. SQL Server Index Myth 5: Clustered Indexes Store Records in Physical Order
  6. SQL Server Index Myth 6: Indexes Always Output in the Same Order
  7. SQL Server Index Myth 7: Fill Factor Is Applied to Indexes During Inserts
  8. SQL Server Index Myth 8 : Deleting form heaps results in unrecoverable space
  9. SQL Server Index Myth 9 : Every Table Should Have a Heap/Clustered Index

For all your application development needs, visit www.verbat.com for a fiscally conscious proposal that meets your needs ( So I can keep this blog going as well!!!!)

Advertisements