Skip to content Skip to sidebar Skip to footer
Showing posts with the label Clustered Index

Inserts With Sequential Guid Key On Clustered Index Not Significantly Faster

In SQL Server 2008 I have tried to reproduce the results from the experiments on clustered index on… Read more Inserts With Sequential Guid Key On Clustered Index Not Significantly Faster

Clustered Indexes On Non-identity Columns To Speed Up Bulk Inserts?

My two questions are: Can I use clustered indexes to speed up bulk inserts in big tables? Can I th… Read more Clustered Indexes On Non-identity Columns To Speed Up Bulk Inserts?

What Does This Sentence Mean: Clustered Indexes Are Stored Physically On The Table?

How are clustered indexes stored on a hard disk? What is the logical order? How do non-clustered i… Read more What Does This Sentence Mean: Clustered Indexes Are Stored Physically On The Table?