|
|
Posted by JXStern on 01/15/07 19:47
On 13 Jan 2007 18:15:11 -0800, wizofaus@hotmail.com wrote:
>Well I found another solution - reindex the table.
>
>I ran
>
>dbcc dbreindex('mytable', ' ', 90) on the initial database, and now the
>problem is gone away. My main concern was that if we did see this
>problem occuring in productoion databases, how could we fix it, other
>than changing the code, and at least now I have such a solution, and
>it's a bit less drastic than exporting and re-importing all the data
>(which potentially could have taken hours).
How large is your table?
Maybe a simple "update statistics" would also fix things?
J.
Navigation:
[Reply to this message]
|