There may be times when we need to restore a database from a non-production or production environment for troubleshooting purposes, and we may encounter a DB size issue or need to know a list of tables with large amounts of data in order to enable purging them. This query returns a list of tables that contain large amounts of data in sequential order. Query to Execute in SQL SELECT s.Name AS SchemaName ,t.Name AS TableName ,p.rows AS RowCounts ,CAST(ROUND((SUM(a.used_pages) / 128.00), 2) AS NUMERIC(36, 2)) AS Used_MB ,CAST(ROUND((SUM(a.total_pages) - SUM(a.used_pages)) / 128.00, 2) AS NUMERIC(36, 2)) AS Unused_MB ,CAST(ROUND((SUM(a.total_pages) / 128.00), 2) AS NUMERIC(36, 2)) AS Total_MB FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER JOIN sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id I
What are OOPS concepts? The main concepts of OOPS used in D365 FO are: Class and Objects Data Abstraction: Showing only the essential information and hiding background details. Encapsulation: Wrapping of data member and method to a single unit. Inheritance Flowing of property of the parent class to the child class. Polymorphism is the property of repeatedly using the same method to perform different things. Interfaces & Abstract Class The class implementing is the interface that implements all interface methods and there will not be any abstract Class requirement. There are many access modifiers available like abstract, protected, virtual, internal, public, and many more that are useful in the abstract Classes. Abstract classes will be very fast when compared to interfaces. Interfaces Abstract Class The interface is the signature for a particular method. Abstract class contains both the in