I’ve recently discussed a few features that Microsoft advises against using, and that I think you should forget exist, too. There was the case where a colleague constantly promoted the deprecated backward compatibility view
sys.sysprocessesinstead of newer dynamic management views (DMVs), and another case where a different colleague took down a production server using SQL Server Profiler.
My latest run-in with things best forgotten is a new stored procedure with an
ntextparameter. I checked and, sure enough, the data type matches the schema for the underlying table. My mind started racing about these older data types to explain why we really shouldn’t be using them anymore:
I can’t remember the last time I saw new SQL Server tables created with
ntext or other deprecated types, but apparently it happens.