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... Continue Reading →
SQL Server Index Myth 2: Primary Keys Are Always Clustered
SQL Server Myth 2 : Primary keys are always clustered