Yesterday, my company upgraded our database (Microsoft SQL Server 2000) to
service pack 4. Today, we started observing queries were taking much longer
than they should. We have managed to track the problem to parameterized decimal
fields in queries. If we remove the parameterization or if we remove the
cfsqltype="cf_sql_decimal" the query takes only 6 reads; if we leave the type
statement in, it takes about 18,000 reads (a difference between a page taking
~16ms and ~800ms). We know that the problem originated with SP4 for MSSQL (the
problem doesn't exist on another server with the same data that hasn't recieved
the update).

Questions:
1. Has anyone else encountered this problem?
2. If so, did you find a work around or fix (either from
Adobe/Macromedia/Allaire or Microsoft)?

FYI: We are running ColdFusion MX 7.0.1.