Posted by Erland Sommarskog on 06/08/06 21:44
Martin (mvirta@olgc.ca) writes:
> ApexSQL Log squawked about "redo for delete cannot be generated for
> tables lacking clustered index". Huh? What the...? We have lots of
> tables without a clustered index.
Probably the people at ApexSQL are like me: they think that every table
should have a clustered index.
If nothing else, fragmentation is easier to keep in check, if you have
a clustered index.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
[Back to original message]
|