You may receive incorrect values when using SCOPE_IDENTITY() and @@IDENTITY posted on Sep 8, 2010 von Frank Kalis in Links
Slow query performance because inaccurate cardinality estimate when using anti-semi join following upgrade from SQL Server 2000 posted on Sep 2, 2010 von Frank Kalis in Links