{"id":502,"date":"2012-03-20T05:43:00","date_gmt":"2012-03-20T05:43:00","guid":{"rendered":"\/blogs\/joe\/post\/Temporary-Statistics-for-Database-Snapshots-in-SQL-Server-2012.aspx"},"modified":"2013-01-02T20:32:11","modified_gmt":"2013-01-03T04:32:11","slug":"temporary-statistics-for-database-snapshots-in-sql-server-2012","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/joe\/temporary-statistics-for-database-snapshots-in-sql-server-2012\/","title":{"rendered":"Temporary Statistics for Database Snapshots in SQL Server 2012"},"content":{"rendered":"

\nYou may have already heard that SQL Server 2012 adds automatic generation of statistics for AlwaysOn availability group readable secondaries, storing the statistics in tempdb.  <\/span>This functionality was also extended to other areas beyond just AlwaysOn availability groups as I’ll demonstrate next…<\/font><\/font>\n<\/p>\n

\nUsing the AdventureWorksDWDenali database, I’ll start by checking the current statistics on the FactInternetSales table:<\/font><\/font>\n<\/p>\n

\nUSE<\/font><\/font><\/span> [AdventureWorksDWDenali]<\/font><\/span><\/font>;<\/font><\/span><\/span><\/font>\n<\/p>\n

\nGO<\/font><\/font><\/span><\/span>\n<\/p>\n

\n<\/font><\/font><\/span>\n<\/p>\n

\n— Confirm statistics on FactInternetSales<\/font><\/font><\/span><\/span>\n<\/p>\n

\nEXEC<\/font><\/font><\/span> sp_helpstats<\/font><\/span> <\/font><\/span>'FactInternetSales'<\/font><\/span><\/font>;<\/font><\/span><\/span><\/font>\n<\/p>\n

\n<\/font><\/font><\/span>\n<\/p>\n

\n\/*<\/font><\/font><\/span><\/span>\n<\/p>\n

\nstatistics_name <\/span>statistics_keys<\/font><\/font><\/span><\/span>\n<\/p>\n

\n_WA_Sys_00000008_1273C1CD  <\/span>SalesTerritoryKey<\/font><\/font><\/span><\/span>\n<\/p>\n

\n_WA_Sys_0000000A_1273C1CD  <\/span>SalesOrderLineNumber<\/font><\/font><\/span><\/span>\n<\/p>\n

\n_WA_Sys_0000000B_1273C1CD  <\/span>RevisionNumber<\/font><\/font><\/span><\/span>\n<\/p>\n

\n_WA_Sys_0000000C_1273C1CD  <\/span>OrderQuantity<\/font><\/font><\/span><\/span>\n<\/p>\n

\n_WA_Sys_0000000D_1273C1CD     <\/span>UnitPrice<\/font><\/font><\/span><\/strong><\/span><\/strong>\n<\/p>\n

\n_WA_Sys_0000000E_1273C1CD  <\/span>ExtendedAmount<\/font><\/font><\/span><\/span>\n<\/p>\n

\n_WA_Sys_0000000F_1273C1CD  <\/span>UnitPriceDiscountPct<\/font><\/font><\/span><\/span>\n<\/p>\n

\n_WA_Sys_00000010_1273C1CD  <\/span>DiscountAmount<\/font><\/font><\/span><\/span>\n<\/p>\n

\n_WA_Sys_00000011_1273C1CD  <\/span>ProductStandardCost<\/font><\/font><\/span><\/span>\n<\/p>\n

\n_WA_Sys_00000012_1273C1CD  <\/span>TotalProductCost<\/font><\/font><\/span><\/span>\n<\/p>\n

\n_WA_Sys_00000013_1273C1CD  <\/span>SalesAmount<\/font><\/font><\/span><\/span>\n<\/p>\n

\n_WA_Sys_00000014_1273C1CD  <\/span>TaxAmt<\/font><\/font><\/span><\/span>\n<\/p>\n

\n_WA_Sys_00000015_1273C1CD  <\/span>Freight<\/font><\/font><\/span><\/span>\n<\/p>\n

\n_WA_Sys_00000016_1273C1CD  <\/span>CarrierTrackingNumber<\/font><\/font><\/span><\/span>\n<\/p>\n

\n_WA_Sys_00000017_1273C1CD  <\/span>CustomerPONumber<\/font><\/font><\/span><\/span>\n<\/p>\n

\n_WA_Sys_00000018_1273C1CD  <\/span>OrderDate<\/font><\/font><\/span><\/span>\n<\/p>\n

\n_WA_Sys_00000019_1273C1CD  <\/span>DueDate<\/font><\/font><\/span><\/span>\n<\/p>\n

\n_WA_Sys_0000001A_1273C1CD  <\/span>ShipDate<\/font><\/font><\/span><\/span>\n<\/p>\n

\n*\/<\/font><\/font><\/span><\/span>\n<\/p>\n

\n<\/font><\/font><\/span>\n<\/p>\n

\nNext, I’m going to add a UnitPrice value to an existing row (creating just one row out of the table with this value):<\/font><\/font>\n<\/p>\n

\nUPDATE<\/font><\/font><\/span> TOP <\/font><\/span>(<\/font><\/span>1)<\/font><\/span> dbo<\/font><\/span>.<\/font><\/span><\/font>FactInternetSales<\/font><\/span><\/span><\/font>\n<\/p>\n

\nSET<\/font><\/font><\/span> UnitPrice<\/font><\/span> =<\/font><\/span> 777.77<\/font>;<\/font><\/span><\/span><\/font>\n<\/p>\n

\n<\/font><\/font>\n<\/p>\n

\nAfter that, I’ll drop the statistics for the UnitPrice column.  <\/span>Why?  <\/span>I want demonstrate a scenario where automatic statistics may not have already been generated due to incoming query requests – but may still be needed for queries against the database snapshot:<\/font><\/font>\n<\/p>\n

\n— UnitPrice stats<\/font><\/font><\/span><\/span>\n<\/p>\n

\nDROP<\/font><\/font><\/span> STATISTICS<\/font><\/span> FactInternetSales<\/font><\/span>.<\/font><\/span>_WA_Sys_0000000D_1273C1CD<\/font><\/span><\/font>;<\/font><\/span><\/span><\/font>\n<\/p>\n

\nGO<\/font><\/font><\/span><\/span>\n<\/p>\n

\n<\/font><\/font><\/span>\n<\/p>\n

\nNow I’ll create a database snapshot on the database:<\/font><\/font>\n<\/p>\n

\n— Create the database snapshot<\/font><\/font><\/span><\/span>\n<\/p>\n

\nCREATE<\/font><\/font><\/span> DATABASE<\/font><\/span> AdventureWorksDWDenali_AWDW_S1<\/font><\/span> <\/font><\/span><\/font>\n<\/p>\n

\nON<\/font><\/font><\/span><\/span>\n<\/p>\n

\n(<\/font><\/font><\/span> NAME<\/font><\/span> =<\/font><\/span> AdventureWorksDWDenali_Data<\/font><\/span>,<\/font><\/span> <\/font><\/span><\/font>\n<\/p>\n

\nFILENAME<\/font><\/font><\/span> =<\/font><\/span> <\/font><\/span><\/font>\n<\/p>\n

\n'C:\\Program Files\\Microsoft SQL Server\\MSSQL11.CAESAR\\MSSQL\\Data\\AdventureWorksDWDenali_AWDW_S1.ss'<\/font><\/font><\/span> <\/font>)<\/font><\/span><\/span><\/font>\n<\/p>\n

\nAS<\/font><\/font><\/span> SNAPSHOT<\/font><\/span> OF<\/font><\/span> AdventureWorksDWDenali<\/font><\/span><\/font>;<\/font><\/span><\/span><\/font>\n<\/p>\n

\nGO<\/font><\/font><\/span>\n<\/p>\n

\n<\/font><\/font>\n<\/p>\n

\nWhat happens if I use the database snapshot to query for a specific UnitPrice value?  <\/span>There are no statistics on the read-write database and now that I’m using the database snapshot, I’m not triggering automatic-statistics on the source database:<\/font><\/font>\n<\/p>\n

\nUSE<\/font><\/font><\/span> AdventureWorksDWDenali_AWDW_S1<\/font><\/span><\/font>;<\/font><\/span><\/span><\/font>\n<\/p>\n

\nGO<\/font><\/font><\/span><\/span>\n<\/p>\n

\n<\/font><\/font><\/span>\n<\/p>\n

\nSELECT<\/font><\/font><\/span> ProductKey<\/font><\/span>,<\/font><\/span> <\/font>ProductStandardCost<\/font><\/span><\/span><\/font>\n<\/p>\n

\nFROM<\/font><\/font><\/span> dbo<\/font><\/span>.<\/font><\/span><\/font>FactInternetSales<\/font><\/span><\/span><\/font>\n<\/p>\n

\nWHERE<\/font><\/font><\/span> UnitPrice<\/font><\/span> =<\/font><\/span> 777.77<\/font>;<\/font><\/span><\/span><\/font>\n<\/p>\n

\n<\/font><\/font>\n<\/p>\n

\nLooking at the actual plan for this query, I see that the estimated rows vs. actual do indeed match (and as an aside – the optimizer “guess” for this predicate would have been 3,852.72 without the supporting stats):<\/font><\/font>\n<\/p>\n

\n\"clip_image001\"<\/a><\/span>\n<\/p>\n

\nBut I can also check to see if there are automatic statistics generated by qualifying is_temporary = 1:<\/font><\/font>\n<\/p>\n

\nSELECT<\/font><\/font><\/span> name<\/font><\/span>,<\/font><\/span> <\/font>stats_id<\/font><\/span><\/span><\/font>\n<\/p>\n

\nFROM<\/font><\/font><\/span> sys<\/font><\/span>.<\/font><\/span>stats<\/font><\/span> <\/font><\/span><\/font>\n<\/p>\n

\nWHERE<\/font><\/font><\/span> OBJECT_ID<\/font><\/span> =<\/font><\/span> object_id<\/font><\/span>(<\/font><\/span>'FactInternetSales'<\/font><\/span><\/font>)<\/font><\/span><\/span><\/font>\n<\/p>\n

\n     <\/font><\/span>AND<\/font><\/span> is_temporary<\/font><\/span> =<\/font><\/span> 1<\/font>;<\/font><\/span><\/font><\/span>\n<\/p>\n

\n<\/font><\/font>\n<\/p>\n

\nThis returns:<\/font><\/font>\n<\/p>\n

\n\"clip_image003\"<\/a><\/span>\n<\/p>\n

\nThe stats name even gave me an additional hint of its origins via the “readonly” naming convention.  <\/span>If I look up the column for the automatically generated temporary stats, I see the following:<\/font><\/font>\n<\/p>\n

\nSELECT<\/font><\/font><\/span>     <\/span>object_name<\/font><\/span>(<\/font><\/span>object_id<\/font><\/span>)<\/font><\/span> tblname<\/font><\/span><\/font>,<\/font><\/span><\/span><\/font>\n<\/p>\n

\n           <\/font><\/span>COL_NAME<\/font><\/span>(<\/font><\/span>object_id<\/font><\/span>,<\/font><\/span> column_id<\/font><\/span>)<\/font><\/span> <\/font>columnname<\/font><\/span><\/font><\/span>\n<\/p>\n

\nFROM<\/font><\/font><\/span> sys<\/font><\/span>.<\/font><\/span><\/font>stats_columns<\/font><\/span><\/span><\/font>\n<\/p>\n

\nWHERE<\/font><\/font><\/span> stats_id<\/font><\/span> =<\/font><\/span> 512000<\/font>;<\/font><\/span><\/span><\/font>\n<\/p>\n

\n<\/font><\/font>\n<\/p>\n

\n\"clip_image005\"<\/a><\/span>\n<\/p>\n

If you need a supporting index, you still need to provide this structure in the read-write database, but when a query can be optimized using statistics alone – this is definitely a welcome new feature.<\/font><\/font><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

You may have already heard that SQL Server 2012 adds automatic generation of statistics for AlwaysOn availability group readable secondaries, storing the statistics in tempdb.  This functionality was also extended to other areas beyond just AlwaysOn availability groups as I’ll demonstrate next… Using the AdventureWorksDWDenali database, I’ll start by checking the current statistics on the […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[],"class_list":["post-502","post","type-post","status-publish","format-standard","hentry","category-performance"],"yoast_head":"\nTemporary Statistics for Database Snapshots in SQL Server 2012 - Joe Sack<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/temporary-statistics-for-database-snapshots-in-sql-server-2012\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Temporary Statistics for Database Snapshots in SQL Server 2012 - Joe Sack\" \/>\n<meta property=\"og:description\" content=\"You may have already heard that SQL Server 2012 adds automatic generation of statistics for AlwaysOn availability group readable secondaries, storing the statistics in tempdb.  This functionality was also extended to other areas beyond just AlwaysOn availability groups as I’ll demonstrate next… Using the AdventureWorksDWDenali database, I’ll start by checking the current statistics on the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/joe\/temporary-statistics-for-database-snapshots-in-sql-server-2012\/\" \/>\n<meta property=\"og:site_name\" content=\"Joe Sack\" \/>\n<meta property=\"article:published_time\" content=\"2012-03-20T05:43:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-01-03T04:32:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/windows-live-writer\/temporary-statistics-for-database-snapsh\/72365d8a\/clip_image001_thumb.png\" \/>\n<meta name=\"author\" content=\"Joseph Sack\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Joseph Sack\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/temporary-statistics-for-database-snapshots-in-sql-server-2012\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/temporary-statistics-for-database-snapshots-in-sql-server-2012\/\",\"name\":\"Temporary Statistics for Database Snapshots in SQL Server 2012 - Joe Sack\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#website\"},\"datePublished\":\"2012-03-20T05:43:00+00:00\",\"dateModified\":\"2013-01-03T04:32:11+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/temporary-statistics-for-database-snapshots-in-sql-server-2012\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/joe\/temporary-statistics-for-database-snapshots-in-sql-server-2012\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/temporary-statistics-for-database-snapshots-in-sql-server-2012\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Performance\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/category\/performance\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Temporary Statistics for Database Snapshots in SQL Server 2012\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/\",\"name\":\"Joe Sack\",\"description\":\"SQL Server Performance Tuning, High Availability and Disaster Recovery Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648\",\"name\":\"Joseph Sack\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g\",\"caption\":\"Joseph Sack\"},\"description\":\"Joe Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail and the real estate industry. Prior to joining SQLskills he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development and high-availability. In 2006 Joe earned the \u201cMicrosoft Certified Master: SQL Server 2005\u201d certification and in 2008 he earned the \u201cMicrosoft Certified Master: SQL Server 2008\u201d certification. In 2009 he took over responsibility for the entire SQL Server Microsoft Certified Master program and held that post until 2011. He was given the SQL Server MVP award in 2013.\",\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/joe\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/josephsack\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/author\/joe\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Temporary Statistics for Database Snapshots in SQL Server 2012 - Joe Sack","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/joe\/temporary-statistics-for-database-snapshots-in-sql-server-2012\/","og_locale":"en_US","og_type":"article","og_title":"Temporary Statistics for Database Snapshots in SQL Server 2012 - Joe Sack","og_description":"You may have already heard that SQL Server 2012 adds automatic generation of statistics for AlwaysOn availability group readable secondaries, storing the statistics in tempdb.  This functionality was also extended to other areas beyond just AlwaysOn availability groups as I’ll demonstrate next… Using the AdventureWorksDWDenali database, I’ll start by checking the current statistics on the […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/joe\/temporary-statistics-for-database-snapshots-in-sql-server-2012\/","og_site_name":"Joe Sack","article_published_time":"2012-03-20T05:43:00+00:00","article_modified_time":"2013-01-03T04:32:11+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/windows-live-writer\/temporary-statistics-for-database-snapsh\/72365d8a\/clip_image001_thumb.png"}],"author":"Joseph Sack","twitter_misc":{"Written by":"Joseph Sack","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/temporary-statistics-for-database-snapshots-in-sql-server-2012\/","url":"https:\/\/www.sqlskills.com\/blogs\/joe\/temporary-statistics-for-database-snapshots-in-sql-server-2012\/","name":"Temporary Statistics for Database Snapshots in SQL Server 2012 - Joe Sack","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#website"},"datePublished":"2012-03-20T05:43:00+00:00","dateModified":"2013-01-03T04:32:11+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/temporary-statistics-for-database-snapshots-in-sql-server-2012\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/joe\/temporary-statistics-for-database-snapshots-in-sql-server-2012\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/temporary-statistics-for-database-snapshots-in-sql-server-2012\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/joe\/"},{"@type":"ListItem","position":2,"name":"Performance","item":"https:\/\/www.sqlskills.com\/blogs\/joe\/category\/performance\/"},{"@type":"ListItem","position":3,"name":"Temporary Statistics for Database Snapshots in SQL Server 2012"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/joe\/","name":"Joe Sack","description":"SQL Server Performance Tuning, High Availability and Disaster Recovery Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/joe\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648","name":"Joseph Sack","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g","caption":"Joseph Sack"},"description":"Joe Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail and the real estate industry. Prior to joining SQLskills he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development and high-availability. In 2006 Joe earned the \u201cMicrosoft Certified Master: SQL Server 2005\u201d certification and in 2008 he earned the \u201cMicrosoft Certified Master: SQL Server 2008\u201d certification. In 2009 he took over responsibility for the entire SQL Server Microsoft Certified Master program and held that post until 2011. He was given the SQL Server MVP award in 2013.","sameAs":["http:\/\/3.209.169.194\/blogs\/joe","https:\/\/twitter.com\/https:\/\/twitter.com\/josephsack"],"url":"https:\/\/www.sqlskills.com\/blogs\/joe\/author\/joe\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts\/502","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/comments?post=502"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts\/502\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/media?parent=502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/categories?post=502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/tags?post=502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}