Warning: Constant WP_TEMP_DIR already defined in /var/www/html/blogs/joe/wp-config.php on line 93
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/joe/wp-config.php:93) in /var/www/html/blogs/joe/wp-includes/rest-api/class-wp-rest-server.php on line 1902
{"id":485,"date":"2012-07-31T06:29:42","date_gmt":"2012-07-31T06:29:42","guid":{"rendered":"\/blogs\/joe\/post\/SQL-Server-2012e28099s-RetrievedFromCache-Attribute.aspx"},"modified":"2013-02-07T15:42:26","modified_gmt":"2013-02-07T23:42:26","slug":"sql-server-2012s-retrievedfromcache-attribute","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/joe\/sql-server-2012s-retrievedfromcache-attribute\/","title":{"rendered":"SQL Server 2012\u2019s RetrievedFromCache Attribute"},"content":{"rendered":"SQL Server 2012 includes a new RetrievedFromCache attribute in the query execution plan.<\/p>\n
Let\u2019s say I execute the following query immediately after executing DBCC FREEPROCCACHE:<\/p>\n
\r\nSELECT\u00a0\u00a0\u00a0\u00a0 p.ProductLine,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SUM(f.SalesAmount) AS TotalSalesAmount\r\nFROM [dbo].[FactInternetSales] AS f\r\nINNER JOIN [dbo].[DimProduct] AS p ON\r\n\u00a0\u00a0\u00a0\u00a0 f.ProductKey = p.ProductKey\r\nGROUP BY p.ProductLine\r\nORDER BY p.ProductLine;\r\n<\/pre>\n