creation_time           last_execution_time     row_no               l1                   total_worker_time                       AvgCPUTime                              LogicalReads         LogicalWrites        execution_count      AggIO                AvgIO                                   query_text                                                                                                                                                                                                                                                       db_name                                                                                                                          object_id
----------------------- ----------------------- -------------------- -------------------- --------------------------------------- --------------------------------------- -------------------- -------------------- -------------------- -------------------- --------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -----------
2008-03-11 12:53:19.697 2008-03-11 12:55:15.053 3                    1                    259.390000                              86.463333333333333333                   49718                2                    3                    49720                16573.333333333333333333                SELECT
	(row_number() over(order by a3.name, a2.name))%2 as l1,
	a3.name AS [schemaname],
	a2.name AS [tablename],
	a1.rows as row_count,
	(a1.reserved + ISNULL(a4.reserved,0))* 8 AS reserved, 
	a1.data * 8 AS data,
	(CASE WHEN (a1.used + ISNULL(a4. NULL                                                                                                                             NULL
2008-03-11 13:00:26.540 2008-03-11 13:00:26.660 6                    0                    72.471000                               72.471000000000000000                   16562                0                    1                    16562                16562.000000000000000000                SELECT
	(row_number() over(order by a3.name, a2.name))%2 as l1,
	a3.name AS [schemaname],
	a2.name AS [tablename],
	a1.rows as row_count,
	(a1.reserved + ISNULL(a4.reserved,0))* 8 AS reserved, 
	a1.data * 8 AS data,
	(CASE WHEN (a1.used + ISNULL(a4. NULL                                                                                                                             NULL
2008-03-11 13:15:38.743 2008-03-11 13:36:48.920 5                    1                    145.430000                              72.715000000000000000                   33052                0                    2                    33052                16526.000000000000000000                SELECT
	(row_number() over(order by a3.name, a2.name))%2 as l1,
	a3.name AS [schemaname],
	a2.name AS [tablename],
	a1.rows as row_count,
	(a1.reserved + ISNULL(a4.reserved,0))* 8 AS reserved, 
	a1.data * 8 AS data,
	(CASE WHEN (a1.used + ISNULL(a4. NULL                                                                                                                             NULL
2008-03-11 13:13:13.633 2008-03-11 13:50:37.290 4                    0                    323.872000                              80.968000000000000000                   66032                0                    4                    66032                16508.000000000000000000                SELECT
	--(row_number() over(order by a3.name, a2.name))%2 as l1,
	a3.name AS [schemaname],
	count(a2.name ) as NumberOftables,
	sum(a1.rows) as row_count,
	sum((a1.reserved + ISNULL(a4.reserved,0))* 8) AS reserved, 
	sum(a1.data * 8) AS data,
	sum( NULL                                                                                                                             NULL
2008-03-11 13:41:41.290 2008-03-11 13:45:55.837 2                    0                    392.260000                              130.753333333333333333                  49470                0                    3                    49470                16490.000000000000000000                SELECT
	(row_number() over(order by a3.name, a2.name))%2 as l1,
	a3.name AS [schemaname],
	a2.name AS [tablename],
	a1.rows as row_count,
	(a1.reserved + ISNULL(a4.reserved,0))* 8 AS reserved, 
	a1.data * 8 AS data,
	(CASE WHEN (a1.used + ISNULL(a4. NULL                                                                                                                             NULL
2008-03-11 13:37:05.723 2008-03-11 13:37:05.843 7                    1                    71.816000                               71.816000000000000000                   16490                0                    1                    16490                16490.000000000000000000                SELECT
	(row_number() over(order by a3.name, a2.name))%2 as l1,
	a3.name AS [schemaname],
	a2.name AS [tablename],
	a1.rows as row_count,
	(a1.reserved + ISNULL(a4.reserved,0))* 8 AS reserved, 
	a1.data * 8 AS data,
	(CASE WHEN (a1.used + ISNULL(a4. NULL                                                                                                                             NULL
2008-03-11 13:16:01.277 2008-03-11 13:16:01.417 17                   1                    12.272000                               12.272000000000000000                   1384                 0                    1                    1384                 1384.000000000000000000                 SELECT
	(row_number() over(order by a3.name, a2.name))%2 as l1,
	a3.name AS [schemaname],
	a2.name AS [tablename],
	a1.rows as row_count,
	(a1.reserved + ISNULL(a4.reserved,0))* 8 AS reserved, 
	a1.data * 8 AS data,
	(CASE WHEN (a1.used + ISNULL(a4. NULL                                                                                                                             NULL
2008-03-11 13:16:15.917 2008-03-11 13:48:24.110 16                   0                    25.138000                               12.569000000000000000                   2756                 0                    2                    2756                 1378.000000000000000000                 SELECT
	--(row_number() over(order by a3.name, a2.name))%2 as l1,
	a3.name AS [schemaname],
	count(a2.name ) as NumberOftables,
	sum(a1.rows) as row_count,
	sum((a1.reserved + ISNULL(a4.reserved,0))* 8) AS reserved, 
	sum(a1.data * 8) AS data,
	sum( NULL                                                                                                                             NULL
2008-03-11 13:15:51.600 2008-03-11 13:15:51.770 15                   1                    12.589000                               12.589000000000000000                   1360                 0                    1                    1360                 1360.000000000000000000                 SELECT
	(row_number() over(order by a3.name, a2.name))%2 as l1,
	a3.name AS [schemaname],
	a2.name AS [tablename],
	a1.rows as row_count,
	(a1.reserved + ISNULL(a4.reserved,0))* 8 AS reserved, 
	a1.data * 8 AS data,
	(CASE WHEN (a1.used + ISNULL(a4. NULL                                                                                                                             NULL
2008-03-11 13:34:20.777 2008-03-11 13:36:39.327 19                   1                    28.477000                               9.492333333333333333                    2325                 0                    3                    2325                 775.000000000000000000                  SELECT
	(row_number() over(order by a3.name, a2.name))%2 as l1,
	a3.name AS [schemaname],
	a2.name AS [tablename],
	a1.rows as row_count,
	(a1.reserved + ISNULL(a4.reserved,0))* 8 AS reserved, 
	a1.data * 8 AS data,
	(CASE WHEN (a1.used + ISNULL(a4. master                                                                                                                           1403152044

(10 row(s) affected)


Fig 1.3