While a game-changer for security ... to include this additional IS NULL or IS NOT NULL syntax. This not only clutters T-SQL code, but forces the execution plan to use an index scan. In SQL Server ...

WHILE loop performance in SQL Server 2008 Your email has been sent ... in a WHERE CURRENT OF clause in an UPDATE or DELETE statement. This option overrides the default capability of a cursor ...