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":507,"date":"2012-02-22T08:19:00","date_gmt":"2012-02-22T08:19:00","guid":{"rendered":"\/blogs\/joe\/post\/SEQUENCE-Object-versus-Modulus-Hash-Partitioning.aspx"},"modified":"2013-01-02T20:32:29","modified_gmt":"2013-01-03T04:32:29","slug":"sequence-object-versus-modulus-hash-partitioning","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/joe\/sequence-object-versus-modulus-hash-partitioning\/","title":{"rendered":"SEQUENCE Object versus Modulus Hash Partitioning"},"content":{"rendered":"

\nLast month I wrote a post called <\/font>Hash Partitioning with SQL Server 2012’s SEQUENCE object and CYCLE argument<\/a><\/font> and I was asked a good question by Eric Humphrey (t<\/u><\/font>witter<\/a><\/font>) about whether there was any advantage of using a sequence object for hash partitioning over an identity\/modulus\/computed-column technique.<\/font>  <\/font><\/span><\/font>\n<\/p>\n

\nAt that point I hadn’t compared the two techniques, but I wanted to perform a test eventually, so here is what I found…  <\/span>This was a quick-and-dirty test, by the way, as I really should have been working on something else (first), but I needed a little “fun” time.<\/font><\/font>\n<\/p>\n

\nBefore testing, I made a <\/font>few minor modifications to the schema<\/a><\/font><\/font> used in my original post:<\/font><\/font>\n<\/p>\n

\n1.<\/font><\/font>      <\/font><\/font><\/span><\/span><\/span>I split the range of the partition function as follows:<\/font><\/font>\n<\/p>\n

\n \n<\/p>\n

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

\nALTER PARTITION FUNCTION pfFactInternetSales () SPLIT RANGE (0)<\/font><\/font>\n<\/p>\n

\n \n<\/p>\n

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

\n2.<\/font><\/font>      <\/font><\/font><\/span><\/span><\/span>I changed the sequence object to be zero-based instead of one-based:<\/font><\/font>\n<\/p>\n

\n \n<\/p>\n

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

\nCREATE SEQUENCE dbo.Seq_FactInternetSales <\/font><\/font>\n<\/p>\n

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

\n               <\/font><\/span>START WITH 0 <\/font><\/font>\n<\/p>\n

\n               <\/font><\/span>INCREMENT BY 1 <\/font><\/font>\n<\/p>\n

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

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

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

\n    <\/font><\/span>CACHE 10;<\/font><\/font>\n<\/p>\n

\nThat is all that was changed with the sequence object technique I used before. <\/font><\/font>As for a modulus technique, I created two additional columns to another version of the FactInternetSales table:<\/font><\/font>\n<\/p>\n

\nProductID int NOT NULL IDENTITY(1,1),<\/font><\/font>\n<\/p>\n

\n               <\/font><\/span>PartitionBucketKey AS ProductID %11  <\/span>PERSISTED,<\/font><\/font>\n<\/p>\n

\n \n<\/p>\n

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

\nAfter adding the columns I referenced the PartitionBucketKey table as the partition key for the clustered index and imported the data from an INSERT…SELECT (as I did with the sequence object method).<\/font><\/font>\n<\/p>\n

\n \n<\/p>\n

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

\nSo did the performance differ between the two techniques?<\/font><\/font>\n<\/p>\n

\n \n<\/p>\n

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

\nHere are the results of eight separate tests (each executed with a cold data cache for the SELECT, truncated destination table and pre-sized data and log files<\/em>):<\/font><\/font>\n<\/p>\n

\n \n<\/p>\n

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

\n\t\t\tTest number<\/font><\/font><\/span><\/strong>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tRows loaded<\/font><\/font><\/span><\/strong>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tBuckets<\/font><\/font><\/span><\/strong>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tHash Partition<\/font><\/font><\/span><\/strong>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tMethod<\/font><\/font><\/span><\/strong>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\t1<\/font><\/font><\/span><\/strong>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t1,207,960 rows<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t11 buckets<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t26 seconds<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tSequence<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\t2<\/font><\/font><\/span><\/strong>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t1,207,960 rows<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t11 buckets<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t26 seconds<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tSequence<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\t3<\/font><\/font><\/span><\/strong>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t1,207,960 rows<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t11 buckets<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t29 seconds<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tSequence<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\t4<\/font><\/font><\/span><\/strong>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t1,207,960 rows<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t11 buckets<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t26 seconds<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tSequence<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\t5<\/font><\/font><\/span><\/strong>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t1,207,960 rows<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t11 buckets<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t27 seconds<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tModulus<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\t6<\/font><\/font><\/span><\/strong>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t1,207,960 rows<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t11 buckets<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t24 seconds<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tModulus<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\t7<\/font><\/font><\/span><\/strong>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t1,207,960 rows<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t11 buckets<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t25 seconds<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tModulus<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\t8<\/font><\/font><\/span><\/strong>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t1,207,960 rows<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t11 buckets<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t26 seconds<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tModulus<\/font><\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

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

\nSo the modulus method seems to perform ever-so-slightly faster than the sequence method.  <\/span>Stylistically, the sequence method involved a more direct way to create X number of hash buckets (basically no calculation necessary).  <\/span>With that said, the execution plans are nearly identical.<\/font><\/font>\n<\/p>\n

\nSequence Plan (estimated cost – 17.4357)<\/font><\/font><\/strong>\n<\/p>\n

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

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

\nModulus Plan (estimated cost – 17.635)<\/font><\/font><\/strong>\n<\/p>\n

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

\nI’m sure there are other variations of this test that I could try out, but that’s all for now. I’m curious about other techniques people may be using (like a CLR function to do the hashing), so please post them here if you have used an interesting variation on this post’s theme.<\/font><\/font><\/p>\n","protected":false},"excerpt":{"rendered":"

Last month I wrote a post called Hash Partitioning with SQL Server 2012’s SEQUENCE object and CYCLE argument and I was asked a good question by Eric Humphrey (twitter) about whether there was any advantage of using a sequence object for hash partitioning over an identity\/modulus\/computed-column technique.  At that point I hadn’t compared the two […]<\/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-507","post","type-post","status-publish","format-standard","hentry","category-performance"],"yoast_head":"\nSEQUENCE Object versus Modulus Hash Partitioning - 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\/sequence-object-versus-modulus-hash-partitioning\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SEQUENCE Object versus Modulus Hash Partitioning - Joe Sack\" \/>\n<meta property=\"og:description\" content=\"Last month I wrote a post called Hash Partitioning with SQL Server 2012’s SEQUENCE object and CYCLE argument and I was asked a good question by Eric Humphrey (twitter) about whether there was any advantage of using a sequence object for hash partitioning over an identity\/modulus\/computed-column technique.  At that point I hadn’t compared the two […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/joe\/sequence-object-versus-modulus-hash-partitioning\/\" \/>\n<meta property=\"og:site_name\" content=\"Joe Sack\" \/>\n<meta property=\"article:published_time\" content=\"2012-02-22T08:19:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-01-03T04:32:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/windows-live-writer\/sequence-object-versus-modulus-hash-part\/359141ab\/clip_image002_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\/sequence-object-versus-modulus-hash-partitioning\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/sequence-object-versus-modulus-hash-partitioning\/\",\"name\":\"SEQUENCE Object versus Modulus Hash Partitioning - Joe Sack\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#website\"},\"datePublished\":\"2012-02-22T08:19:00+00:00\",\"dateModified\":\"2013-01-03T04:32:29+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/sequence-object-versus-modulus-hash-partitioning\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/joe\/sequence-object-versus-modulus-hash-partitioning\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/sequence-object-versus-modulus-hash-partitioning\/#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\":\"SEQUENCE Object versus Modulus Hash Partitioning\"}]},{\"@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":"SEQUENCE Object versus Modulus Hash Partitioning - 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\/sequence-object-versus-modulus-hash-partitioning\/","og_locale":"en_US","og_type":"article","og_title":"SEQUENCE Object versus Modulus Hash Partitioning - Joe Sack","og_description":"Last month I wrote a post called Hash Partitioning with SQL Server 2012’s SEQUENCE object and CYCLE argument and I was asked a good question by Eric Humphrey (twitter) about whether there was any advantage of using a sequence object for hash partitioning over an identity\/modulus\/computed-column technique.  At that point I hadn’t compared the two […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/joe\/sequence-object-versus-modulus-hash-partitioning\/","og_site_name":"Joe Sack","article_published_time":"2012-02-22T08:19:00+00:00","article_modified_time":"2013-01-03T04:32:29+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/windows-live-writer\/sequence-object-versus-modulus-hash-part\/359141ab\/clip_image002_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\/sequence-object-versus-modulus-hash-partitioning\/","url":"https:\/\/www.sqlskills.com\/blogs\/joe\/sequence-object-versus-modulus-hash-partitioning\/","name":"SEQUENCE Object versus Modulus Hash Partitioning - Joe Sack","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#website"},"datePublished":"2012-02-22T08:19:00+00:00","dateModified":"2013-01-03T04:32:29+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/sequence-object-versus-modulus-hash-partitioning\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/joe\/sequence-object-versus-modulus-hash-partitioning\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/sequence-object-versus-modulus-hash-partitioning\/#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":"SEQUENCE Object versus Modulus Hash Partitioning"}]},{"@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\/507","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=507"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts\/507\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/media?parent=507"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/categories?post=507"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/tags?post=507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}