Tag Archives: MSSQL Server index performance

SQL Server Index Myth 9 : Every Table Should Have a Heap/Clustered Index


SQL Server Index Myth 8 : Every Table Should Have a Heap/Clustered Index

SQL Server Index Myth 8 : Deleting form heaps results in unrecoverable space


SQL Server Index Myth 8 : Deleting form heaps results in unrecoverable space

SQL Server Index Myth 5: Clustered Indexes Store Records in Physical Order


SQL Server Index Myth 5: Clustered Indexes Store Records in Physical Order

SQL Server Index Myth 4: Any Column Can Be Filtered in Multicolumn Indexes


SQL Server Index Myth 4: Any Column Can Be Filtered in Multicolumn Indexes

SQL Server Index Myth 3: Online Index Operations Don’t Block


One of the advantages of SQL Server Enterprise Edition is the ability to build indexes online. During an online index build, the table on which the index is being created will still be available for queries and data modifications. This feature can be extremely useful when a database needs to be accessed and maintenance windows […]
Read More »

SQL Server Index Myth 2: Primary Keys Are Always Clustered


SQL Server Myth 2 : Primary keys are always clustered

SQL Server Index Myth 1 : Databases Don’t Need Indexes


Usually when developers are building applications, one or more databases are created to store data for the application. In many development processes, the focus is on adding new features with the mantra “Performance will work itself out.” An unfortunate result is that there are many databases that get developed and deployed without indexes being built […]
Read More »

Indexing Best Practices


MSSQL Server Indexing Best Practices

Indexing Tool : Database Engine Tuning Advisor


Indexing Tool : Database Engine Tuning Advisor

Indexing Tool : Missing Index Dynamic Management Objects (DMO)


Indexing Tools:Missing Index Dynamic Management Objects (DMO)