FIX: Floating Point Exception (Error 3628) Might Occur for Queries That Need Merged Histograms
Dec.12, 2010 in
Uncategorized
Symptoms
The following floating-point exception error message might occur for queries that require a “merged” histogram:
Server: Msg 3628, Level 16, State 1, Line 2 A floating point exception occurred in the user process. Current transaction is canceled.
Resolution
A float overflow exception occurs in SQL Server when it combines the histograms for two indexes to handle the cardinality estimation for outer-join operators.

Leave a Reply