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!!!!)