WRITETEXT, UPDATETEXT, READTEXT
|
VARCHAR
|
GROUP BY ALL
|
UNION or a derived table
|
FASTFIRSTROW
|
FAST n
|
SETUSER
|
EXECUTE AS
|
CREATE RULE
|
CHECK constraints
|
PASSWORD, MEDIAPASSWORD in BACKUP or RESTORE
|
use access control on the directory or WITH RESTRICTED_USER for RESTORE |
DBCC DBREINDEX
|
ALTER INDEX REBUILD
|
DBCC INDEXDEFRAG
|
ALTER INDEX DEFRAG
|
DBCC SHOWCONTIG
|
sys.dm_db_index_physical_stats
|
DBCC CONCURRENCYVIOLATION |
no replacement |
SET ROWCOUNT
|
TOP(n)
|
SET REMOTE_PROC_TRANSACTIONS
|
distributed queries that reference linked servers (sp_addlinkedserver) |
RAISERROR @Errno @ErrMsg
|
the RAISERROR syntax using parentheses |
DROP INDEX with two-part name |
Move table (and database) to an ON clause |
String literals as column aliases |
Remove the quotes around the alias. Use square brackets if escaping is necessary |
Numbered procedures |
Replace with un-numbered procedures |
System stored procedure |
no replacement |
fn_virtualservernodes
|
sys.dm_os_cluster_nodes
|
fn_servershareddrives
|
sys.dm_io_cluster_shared_drives
|
GRANT / DENY / REVOKE ALL
|
List the specific permissions |
TORN_PAGE_DETECTION
|
checksum |
TAPE
|
DISK or URL
|
Table hint without WITH |
WITH(hint)
|
