Check if your dynamic T-SQL statement is valid
I create this stored procedure and use in my scripts and codes.
I create this stored procedure and use in my scripts and codes.
dm_exec_function_stats
Recommendation for potentially missing indexes. Note: The indexes analysis requires more time, so you may run this query scheduled, saving the output results for a further deeper analysis Missing index help to improve performance.
sys.dm_db_partition_stats: Returns page and row-count information for every partition in the current database. SQL Server Objects with space used https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-partition-stats-transact-sql?view=sql-server-ver15
This query returns compression objects and their properties from database.
This query returns tables that contain instead of triggers. You can use NOT EXISTS in the WHERE clause to find the tables not having INSTEAD OF triggers. Other References: