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

• Next in forum: Re: Dump of databasse
• Prev in forum: Re: Store program EXE in table?
• Thread view: Re: Log Explorer vs. ApexSQL Log vs. SQL Log-Rescue

[Reply to this message]