Index Optimization Tips: "Avoid creating a clustered index based on an incrementing key."
That's a surprising tip - though could be logical. I wonder if I/O bottleneck is an issue, when there is only 1 filegroup used in the database (ro for the table)...
Showing posts with label mssql. Show all posts
Showing posts with label mssql. Show all posts
Wednesday, February 17, 2010
Subscribe to:
Posts (Atom)