SQL Server: Compare Database Tables/Indexes/Views/SP’s etc. For Differences Across Instances

There are a bunch of tools in the market to do the database comparisons for differences but if you want to do it for free (and programmatically)  at a basic level, you could use the method outlined below. For me, this came about as a result of an user asking "So, what is different between …

Advertisement

Oracle – Quick Tip – Find Table & Index Size (SQL Server Equivalent Of sp_spaceused)

Often, a common requirement would involve determining the space usage by an Oracle table and/or index. Knowing that the information in stored in the system views, we can query for the size as follows (just substitute the table name): OWNER TABLE_NAME INDEX_NAME SIZE_MB MY_TABLE_OWNER MY_TABLE_NAME 3929 MY_TABLE_OWNER MY_TABLE_NAME MY_TABLE_NAME_PK 436 MY_TABLE_OWNER MY_TABLE_NAME MY_TABLE_NAME_IDX02 379 MY_TABLE_OWNER …