text: /*
  	=============================
  	   Row count per partition
  	=============================
  	This query will use sys.partitions to return the row count in each partition
  	for the specified table.
  	
  	Source: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-partition
  */
  SELECT  QUOTENAME(s.[name])+'.'+QUOTENAME(t.[name]) as Table_name
  ,       i.[name] as Index_name
  ,       p.partition_number as Partition_nmbr
  ,       p.[rows] as Row_count
  ,       p.[data_compression_desc] as Data_Compression_desc
  FROM    sys.partitions p
  JOIN    sys.tables     t    ON    p.[object_id]   = t.[object_id]
  JOIN    sys.schemas    s    ON    t.[schema_id]   = s.[schema_id]
  JOIN    sys.indexes    i    ON    p.[object_id]   = i.[object_Id]
                              AND   p.[index_Id]    = i.[index_Id]
  WHERE t.[name] = 'FactInternetSales'
  ;