SQL Server performance tip - Do not use NOT IN clause in Subquery use LEFT OUTER JOIN instead

SQL server query to search object name in database

SQL query to search a column name in all tables