Is it a best practice to contrast table and dependent view metadata to target which views to refresh?
We have non-indexed views created on vendor tables. When they change table structure or column definitions we run sp_refreshview as needed. What is the viability of a script to contrast the table ...
How do I get a list of all the partitioned tables in my database? Which system tables/DMVs should I be looking at?
I want to search for a string in the names of the columns present in a database. I’m working on a maintenance project and some of the databases I deal with have more than 150 tables, so I'm looking ...