Tech-Bits

select distinct t.name from sys.partitions p inner join sys.tables t on p.object_id = t.object_id where p.partition_number <> 1 Key Words : SQL Server 2012

public   static   string  JsonPrettify( string  json) {      using  ( var  stringReader =  new   StringReader (json))      using  ( var  stringWriter =  new   StringWriter ())     {          var  jsonReader =  new   JsonTextReader (stringReader);          var  jsonWriter =  new   JsonTextWriter (stringWriter) { Formatting =  Formatting .Indented };         jsonWriter.WriteToken(jsonReader);          return  stringWriter.ToString();     } }

SELECT   SchemaName = c.table_schema,          TableName = c.table_name,          ColumnName = c.column_name,          DataType = data_type FROM     information_schema.columns c          INNER JOIN information_schema.tables t            ON c.table_name = t.table_name               AND c.table_schema = t.table_schema               AND t.table_type = 'BASE TABLE' ORDER BY SchemaName,          TableName,          ordinal_position

SELECT     t.NAME AS TableName,      p.rows AS RowCounts,     CONVERT(DECIMAL,SUM(a.total_pages)) * 8 / 1024 / 1024 AS TotalSpaceGB,     SUM(a.used_pages)  * 8 / 1024 / 1024 AS UsedSpaceGB ,     (SUM(a.total_pages) - SUM(a.used_pages)) * 8 / 1024 / 1024 AS UnusedSpaceGB, CONVERT(DECIMAL,SUM(a.total_pages)) 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 LEFT OUTER JOIN     sys.schemas s ON t.schema_id = s.schema_id WHERE      t.is_ms_shipped = 0     AND i.OBJECT_ID > 255 GROUP BY     t.Name, s.Name, p.Rows ORDER BY     TotalSpaceGB DESC, t.Name

SELECT      sys.databases.name,              CONVERT(VARCHAR,SUM(size)*8/1024)+' MB' AS [Total disk space]  FROM        sys.databases  JOIN        sys.master_files  ON          sys.databases.database_id=sys.master_files.database_id  GROUP BY    sys.databases.name  ORDER BY    sys.databases.name