|
|
Posted by Bill on 10/01/53 11:32
Thanks Stu I'm sure that's it. I'll investigate tomorrow.
Appreciate your help.
Bill
On 20 Nov 2005 06:05:50 -0800, "Stu" <stuart.ainsworth@gmail.com>
wrote:
>Although your primary key is dubious, the datatype and contents are not
>the issue. What are your indexes like? If you do not have an index on
>the datefield, and your clustered index is on the primary key that
>you've identified, then your delete statement is battling some serioud
>fragmentation issues.
>
>Stu
Navigation:
[Reply to this message]
|