Posted by Erland Sommarskog on 08/21/07 21:23

Massa Batheli (mngong@gmail.com) writes:
> Erland Thanks for your response as usual
> The maintenance plan was intended to troubleshoot the process .

I don't think floating-point errors are due to poor statistics or
fragmented indexes. You may be able to get rid of the error that
way if you get a different plan, that does not provoke the error.
But in that case, you never know when it comes back and bite you
again.

--
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: ssis EXEC command
• Prev in forum: Re: MS SQL dealing with duplicate columns in rows?
• Thread view: Re: A floating point exception occurred in the user process

[Reply to this message]