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 … Continue reading Oracle – Quick Tip – Find Table & Index Size (SQL Server Equivalent Of sp_spaceused)
Tag: Object
SQL Server – Find Effective Permissions of An User At Database, Server or Object Level – The Right Way!
Permissions are complex! Permissions management is not easy. You have a lot to deal with Direct user privileges via grants Privileges to AD Group login of which user is part of User could be part of multiple AD groups which have a login on the instance Privileges granted to the role that user is in … Continue reading SQL Server – Find Effective Permissions of An User At Database, Server or Object Level – The Right Way!
PowerShell – Update-Object – Function to add/update object properties
It is not that no one could write this function. In fact, anyone could, but no one would! If someone did, everyone would use it - a function to add/update properties of an object. More precisely, a function that Adds new properties Do appropriate checks to see property existence Ignore or alert if properties are missing Default … Continue reading PowerShell – Update-Object – Function to add/update object properties
SQL Jana 