{"id":1107,"date":"2019-09-20T10:50:38","date_gmt":"2019-09-20T15:50:38","guid":{"rendered":"http:\/\/www.sqlnuggets.com\/?p=1107"},"modified":"2019-09-23T08:12:04","modified_gmt":"2019-09-23T13:12:04","slug":"sql-server-metrics-pack-update-september-2019","status":"publish","type":"post","link":"https:\/\/sqlnuggets.com\/sql-server-metrics-pack-update-september-2019\/","title":{"rendered":"SQL Server Metrics Pack Update &#8211; September 2019"},"content":{"rendered":"\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"586\" src=\"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/07\/binary-797263_1280-e1502824772680-1024x586.jpg\" alt=\"\" class=\"wp-image-490\" srcset=\"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/07\/binary-797263_1280-e1502824772680-1024x586.jpg 1024w, https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/07\/binary-797263_1280-e1502824772680-300x172.jpg 300w, https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/07\/binary-797263_1280-e1502824772680-768x439.jpg 768w, https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/07\/binary-797263_1280-e1502824772680.jpg 1280w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>This morning I updated the Index Metrics piece of <a href=\"https:\/\/github.com\/ericcobb\/SQL-Server-Metrics-Pack\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"SQL Server Metrics Pack (opens in a new tab)\">SQL Server Metrics Pack<\/a>.  This update mainly introduced some new functionality, with a few minor bug fixes.  The two big enhancements are the capability to generate and store CREATE INDEX scripts and support for Columnstore indexes. <\/p>\n\n\n\n<p>Creating index scripts seems pretty straight forward, until you start factoring in the additional settings to go along with the scripts, such as compression, fill factor, etc.  And then you have the differences in the statements between Clustered\/Nonclustered indexes and Columnstore indexes, so it took me a little while to get it all sorted out.<\/p>\n\n\n\n<p>Here are the list of updates:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Added the capability to generate CREATE INDEX scripts<\/li><li>Changed hash algorithm to account for last DB restore date<\/li><li>Added &#8220;<em>loadAllIndexMetrics<\/em>&#8221; procedure that will take index snapshots of all databases on a server<\/li><li>Added checks and scripting capabilities for Columnstore indexes<\/li><li>Updated views to include generated CREATE and DROP SQL scripts<\/li><li>Added &#8220;<em>vwIndexMetrics_GetScripts<\/em>&#8221; view specifically for pulling the generated SQL scripts<\/li><\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This morning I updated the Index Metrics piece of SQL Server Metrics Pack. This update mainly introduced some new functionality, with a few minor bug fixes. The two big enhancements &#8230;<\/p>\n","protected":false},"author":2,"featured_media":490,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[24,57,7],"tags":[25,26,27,58],"class_list":["post-1107","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-indexes","category-open-source-projects","category-tools","tag-clustered-indexes","tag-index-basics","tag-nonclustered-indexes","tag-sql-metrics-pack"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server Metrics Pack Update - September 2019 - SQL Nuggets<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.sqlnuggets.com\/sql-server-metrics-pack-update-september-2019\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Metrics Pack Update - September 2019 - SQL Nuggets\" \/>\n<meta property=\"og:description\" content=\"This morning I updated the Index Metrics piece of SQL Server Metrics Pack. This update mainly introduced some new functionality, with a few minor bug fixes. The two big enhancements ...\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.sqlnuggets.com\/sql-server-metrics-pack-update-september-2019\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Nuggets\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-20T15:50:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-23T13:12:04+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.sqlnuggets.com\/wp-content\/uploads\/2017\/07\/binary-797263_1280-e1502824772680.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"732\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Eric Cobb\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@cfgears\" \/>\n<meta name=\"twitter:site\" content=\"@sqlnugg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Eric Cobb\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-server-metrics-pack-update-september-2019\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-server-metrics-pack-update-september-2019\\\/\"},\"author\":{\"name\":\"Eric Cobb\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/person\\\/210536254addbc1b9d2d95dc1448b38a\"},\"headline\":\"SQL Server Metrics Pack Update &#8211; September 2019\",\"datePublished\":\"2019-09-20T15:50:38+00:00\",\"dateModified\":\"2019-09-23T13:12:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-server-metrics-pack-update-september-2019\\\/\"},\"wordCount\":175,\"commentCount\":1,\"publisher\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\"},\"image\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-server-metrics-pack-update-september-2019\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/binary-797263_1280-e1502824772680.jpg\",\"keywords\":[\"Clustered Indexes\",\"Index Basics\",\"Nonclustered Indexes\",\"SQL Metrics Pack\"],\"articleSection\":[\"Indexes\",\"Open Source Projects\",\"Tools\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-server-metrics-pack-update-september-2019\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-server-metrics-pack-update-september-2019\\\/\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-server-metrics-pack-update-september-2019\\\/\",\"name\":\"SQL Server Metrics Pack Update - September 2019 - SQL Nuggets\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-server-metrics-pack-update-september-2019\\\/#primaryimage\"},\"image\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-server-metrics-pack-update-september-2019\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/binary-797263_1280-e1502824772680.jpg\",\"datePublished\":\"2019-09-20T15:50:38+00:00\",\"dateModified\":\"2019-09-23T13:12:04+00:00\",\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-server-metrics-pack-update-september-2019\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-server-metrics-pack-update-september-2019\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-server-metrics-pack-update-september-2019\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/binary-797263_1280-e1502824772680.jpg\",\"contentUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/binary-797263_1280-e1502824772680.jpg\",\"width\":1280,\"height\":732},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-server-metrics-pack-update-september-2019\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Metrics Pack Update &#8211; September 2019\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#website\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\",\"name\":\"SQL Nuggets\",\"description\":\"Nuggets Of SQL Server Knowledge\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/www.sqlnuggets.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\",\"name\":\"SQL Nuggets\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/website-logo.jpg\",\"contentUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/website-logo.jpg\",\"width\":320,\"height\":54,\"caption\":\"SQL Nuggets\"},\"image\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/sqlnugg\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/ericcobb\\\/\"]},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/person\\\/210536254addbc1b9d2d95dc1448b38a\",\"name\":\"Eric Cobb\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg\",\"caption\":\"Eric Cobb\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/cfgears\"],\"url\":\"https:\\\/\\\/sqlnuggets.com\\\/author\\\/eric-cobb\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server Metrics Pack Update - September 2019 - SQL Nuggets","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":"http:\/\/www.sqlnuggets.com\/sql-server-metrics-pack-update-september-2019\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Metrics Pack Update - September 2019 - SQL Nuggets","og_description":"This morning I updated the Index Metrics piece of SQL Server Metrics Pack. This update mainly introduced some new functionality, with a few minor bug fixes. The two big enhancements ...","og_url":"http:\/\/www.sqlnuggets.com\/sql-server-metrics-pack-update-september-2019\/","og_site_name":"SQL Nuggets","article_published_time":"2019-09-20T15:50:38+00:00","article_modified_time":"2019-09-23T13:12:04+00:00","og_image":[{"width":1280,"height":732,"url":"http:\/\/www.sqlnuggets.com\/wp-content\/uploads\/2017\/07\/binary-797263_1280-e1502824772680.jpg","type":"image\/jpeg"}],"author":"Eric Cobb","twitter_card":"summary_large_image","twitter_creator":"@cfgears","twitter_site":"@sqlnugg","twitter_misc":{"Written by":"Eric Cobb","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.sqlnuggets.com\/sql-server-metrics-pack-update-september-2019\/#article","isPartOf":{"@id":"http:\/\/www.sqlnuggets.com\/sql-server-metrics-pack-update-september-2019\/"},"author":{"name":"Eric Cobb","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/person\/210536254addbc1b9d2d95dc1448b38a"},"headline":"SQL Server Metrics Pack Update &#8211; September 2019","datePublished":"2019-09-20T15:50:38+00:00","dateModified":"2019-09-23T13:12:04+00:00","mainEntityOfPage":{"@id":"http:\/\/www.sqlnuggets.com\/sql-server-metrics-pack-update-september-2019\/"},"wordCount":175,"commentCount":1,"publisher":{"@id":"http:\/\/www.sqlnuggets.com\/#organization"},"image":{"@id":"http:\/\/www.sqlnuggets.com\/sql-server-metrics-pack-update-september-2019\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/07\/binary-797263_1280-e1502824772680.jpg","keywords":["Clustered Indexes","Index Basics","Nonclustered Indexes","SQL Metrics Pack"],"articleSection":["Indexes","Open Source Projects","Tools"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/www.sqlnuggets.com\/sql-server-metrics-pack-update-september-2019\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/www.sqlnuggets.com\/sql-server-metrics-pack-update-september-2019\/","url":"http:\/\/www.sqlnuggets.com\/sql-server-metrics-pack-update-september-2019\/","name":"SQL Server Metrics Pack Update - September 2019 - SQL Nuggets","isPartOf":{"@id":"http:\/\/www.sqlnuggets.com\/#website"},"primaryImageOfPage":{"@id":"http:\/\/www.sqlnuggets.com\/sql-server-metrics-pack-update-september-2019\/#primaryimage"},"image":{"@id":"http:\/\/www.sqlnuggets.com\/sql-server-metrics-pack-update-september-2019\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/07\/binary-797263_1280-e1502824772680.jpg","datePublished":"2019-09-20T15:50:38+00:00","dateModified":"2019-09-23T13:12:04+00:00","breadcrumb":{"@id":"http:\/\/www.sqlnuggets.com\/sql-server-metrics-pack-update-september-2019\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.sqlnuggets.com\/sql-server-metrics-pack-update-september-2019\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.sqlnuggets.com\/sql-server-metrics-pack-update-september-2019\/#primaryimage","url":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/07\/binary-797263_1280-e1502824772680.jpg","contentUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/07\/binary-797263_1280-e1502824772680.jpg","width":1280,"height":732},{"@type":"BreadcrumbList","@id":"http:\/\/www.sqlnuggets.com\/sql-server-metrics-pack-update-september-2019\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/www.sqlnuggets.com\/"},{"@type":"ListItem","position":2,"name":"SQL Server Metrics Pack Update &#8211; September 2019"}]},{"@type":"WebSite","@id":"http:\/\/www.sqlnuggets.com\/#website","url":"http:\/\/www.sqlnuggets.com\/","name":"SQL Nuggets","description":"Nuggets Of SQL Server Knowledge","publisher":{"@id":"http:\/\/www.sqlnuggets.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.sqlnuggets.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/www.sqlnuggets.com\/#organization","name":"SQL Nuggets","url":"http:\/\/www.sqlnuggets.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/logo\/image\/","url":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2023\/11\/website-logo.jpg","contentUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2023\/11\/website-logo.jpg","width":320,"height":54,"caption":"SQL Nuggets"},"image":{"@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/sqlnugg","https:\/\/www.linkedin.com\/in\/ericcobb\/"]},{"@type":"Person","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/person\/210536254addbc1b9d2d95dc1448b38a","name":"Eric Cobb","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg","url":"https:\/\/secure.gravatar.com\/avatar\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg","caption":"Eric Cobb"},"sameAs":["https:\/\/x.com\/cfgears"],"url":"https:\/\/sqlnuggets.com\/author\/eric-cobb\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/07\/binary-797263_1280-e1502824772680.jpg","jetpack_shortlink":"https:\/\/wp.me\/pdyDvE-hR","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":790,"url":"https:\/\/sqlnuggets.com\/sql-scripts-how-to-find-filtered-indexes\/","url_meta":{"origin":1107,"position":0},"title":"SQL Scripts: How To Find Filtered Indexes","author":"Eric Cobb","date":"May 9, 2018","format":false,"excerpt":"Filtered indexes are one of those neat little SQL Server features that a lot of people don't seem to know about, or if they do they don't use them very much.\u00a0 While I agree that putting a filter on every index probably isn't a good idea, there are cases where\u2026","rel":"","context":"In &quot;Indexes&quot;","block_context":{"text":"Indexes","link":"https:\/\/sqlnuggets.com\/category\/indexes\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/06\/board-electronics-computer-data-processing-50711-e1498160567831.jpeg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/06\/board-electronics-computer-data-processing-50711-e1498160567831.jpeg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/06\/board-electronics-computer-data-processing-50711-e1498160567831.jpeg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/06\/board-electronics-computer-data-processing-50711-e1498160567831.jpeg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/06\/board-electronics-computer-data-processing-50711-e1498160567831.jpeg?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":209,"url":"https:\/\/sqlnuggets.com\/index-basics-nonclustered-indexes-part-1\/","url_meta":{"origin":1107,"position":1},"title":"Index Basics: Nonclustered Indexes, Part 1","author":"Eric Cobb","date":"February 18, 2016","format":false,"excerpt":"In SQL Server, an index is used to\u00a0speed the retrieval of data\u00a0from a\u00a0table. Indexes are built from one or more columns in the table, and SQL Server uses these Indexes to look up and retrieve data quickly and efficiently. \u00a0In order to effectively use Indexes in SQL Server, it's important\u2026","rel":"","context":"In &quot;Indexes&quot;","block_context":{"text":"Indexes","link":"https:\/\/sqlnuggets.com\/category\/indexes\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1449,"url":"https:\/\/sqlnuggets.com\/disabling-an-index-drops-compression\/","url_meta":{"origin":1107,"position":2},"title":"Disabling An Index Drops Compression","author":"Eric Cobb","date":"September 1, 2020","format":false,"excerpt":"This post is more of an FYI, and to remind myself in case I run into it again down the road. Here at work we have a very large, very intensive data load that disables and rebuilds indexes as part of the process. We recently added compression to many of\u2026","rel":"","context":"In &quot;Configurations&quot;","block_context":{"text":"Configurations","link":"https:\/\/sqlnuggets.com\/category\/configurations\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2020\/08\/puzzle-1765847_1920.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2020\/08\/puzzle-1765847_1920.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2020\/08\/puzzle-1765847_1920.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2020\/08\/puzzle-1765847_1920.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2020\/08\/puzzle-1765847_1920.jpg?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2020\/08\/puzzle-1765847_1920.jpg?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":1113,"url":"https:\/\/sqlnuggets.com\/recover-deleted-indexes-with-sql-server-metrics-pack\/","url_meta":{"origin":1107,"position":3},"title":"Recover Deleted Indexes With SQL Server Metrics Pack","author":"Eric Cobb","date":"October 22, 2019","format":false,"excerpt":"In my latest enhancement to SQL Server Metrics Pack , I added a new feature to the index metrics scripts that automatically generates a CREATE INDEX script and stores it in the database along with the metrics for each index. (read more about that here) I'm really excited about this\u2026","rel":"","context":"In &quot;Indexes&quot;","block_context":{"text":"Indexes","link":"https:\/\/sqlnuggets.com\/category\/indexes\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/04\/black-and-white-blank-challenge-262488-e1523887336460.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/04\/black-and-white-blank-challenge-262488-e1523887336460.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/04\/black-and-white-blank-challenge-262488-e1523887336460.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/04\/black-and-white-blank-challenge-262488-e1523887336460.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/04\/black-and-white-blank-challenge-262488-e1523887336460.jpg?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/04\/black-and-white-blank-challenge-262488-e1523887336460.jpg?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":468,"url":"https:\/\/sqlnuggets.com\/sql-scripts-find-index-usage\/","url_meta":{"origin":1107,"position":4},"title":"SQL Scripts: How To Find Index Usage","author":"Eric Cobb","date":"July 11, 2017","format":false,"excerpt":"This post is part of an ongoing\u00a0SQL Scripts\u00a0series, in which I list useful queries that I use in my day to day database administration. If you are interested in code that will Persist And Aggregate Index Statistics\u00a0for your server, take a look at my\u00a0SQL Server Metrics Pack\u00a0project that is available\u2026","rel":"","context":"In &quot;Indexes&quot;","block_context":{"text":"Indexes","link":"https:\/\/sqlnuggets.com\/category\/indexes\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/06\/board-electronics-computer-data-processing-50711-e1498160567831.jpeg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/06\/board-electronics-computer-data-processing-50711-e1498160567831.jpeg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/06\/board-electronics-computer-data-processing-50711-e1498160567831.jpeg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/06\/board-electronics-computer-data-processing-50711-e1498160567831.jpeg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/06\/board-electronics-computer-data-processing-50711-e1498160567831.jpeg?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":449,"url":"https:\/\/sqlnuggets.com\/sql-scripts-find-index-fragmentation\/","url_meta":{"origin":1107,"position":5},"title":"SQL Scripts: How To Find Index Fragmentation","author":"Eric Cobb","date":"June 22, 2017","format":false,"excerpt":"This is the first post in\u00a0an ongoing SQL Scripts series, in which I list useful queries that I use in my day to day database administration. What Is Index Fragmentation? Over time, as records are inserted, updated, and deleted, your tables and indexes become fragmented. \u00a0This fragmentation can lead to\u2026","rel":"","context":"In &quot;Indexes&quot;","block_context":{"text":"Indexes","link":"https:\/\/sqlnuggets.com\/category\/indexes\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/06\/board-electronics-computer-data-processing-50711-e1498160567831.jpeg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/06\/board-electronics-computer-data-processing-50711-e1498160567831.jpeg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/06\/board-electronics-computer-data-processing-50711-e1498160567831.jpeg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/06\/board-electronics-computer-data-processing-50711-e1498160567831.jpeg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/06\/board-electronics-computer-data-processing-50711-e1498160567831.jpeg?resize=1050%2C600&ssl=1 3x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/1107","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/comments?post=1107"}],"version-history":[{"count":0,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/1107\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/media\/490"}],"wp:attachment":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/media?parent=1107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/categories?post=1107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/tags?post=1107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}