How to find similar index in SQL Server Query
This query help to find duplicate index by column name.
This query help to find duplicate index by column name.
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:
This query returns table name which contains more than one trigger.
Return table name with schema which contains xml columns in databases
A database architecture of business application which contain Large volume of data and perform their high performance and availability standards.