{"id":277,"date":"2016-11-08T16:09:09","date_gmt":"2016-11-08T22:09:09","guid":{"rendered":"http:\/\/www.sqlnuggets.com\/?p=277"},"modified":"2016-11-08T16:09:09","modified_gmt":"2016-11-08T22:09:09","slug":"finding-recurring-index-fragmentation-issues","status":"publish","type":"post","link":"https:\/\/sqlnuggets.com\/finding-recurring-index-fragmentation-issues\/","title":{"rendered":"Finding Recurring Index Fragmentation Issues"},"content":{"rendered":"<p>One of the nice things about <a href=\"https:\/\/ola.hallengren.com\/\" target=\"_blank\">Ola Hallengren&#8217;s maintenance solution<\/a> is that it has the option to log its operations to a table. \u00a0This gives you ability to do a little data mining on your maintenance operations and help identify some areas that may need your attention. \u00a0(Quick tangent: If you&#8217;re not currently using Ola&#8217;s script, you really should check it\u00a0out!)<\/p>\n<p>One of the things I was curious about was how\u00a0many indexes have regularly recurring fragmentation issues, and how often. \u00a0So, I sat down this morning and spent about a\u00a0minute coming up with this query against the CommandLog table, which is where Ola&#8217;s script logs its operations.<\/p>\n<pre class=\"lang:tsql decode:true\">SELECT TOP 100 [DatabaseName], [ObjectName], [IndexName], count(*) as [Frequency],\r\n\t\tCASE WHEN ([Command] LIKE '{9aaef31dc5e5b7f5049f8f082b0a92ca8701bd6baf49d5704ff4650a929dabe3}REBUILD{9aaef31dc5e5b7f5049f8f082b0a92ca8701bd6baf49d5704ff4650a929dabe3}') THEN 'REBUILD' ELSE 'REORGANIZE' END AS [TYPE]\r\nFROM [dbo].[CommandLog]\r\nWHERE [commandtype] = 'ALTER_INDEX' \r\nAND [starttime] &gt; DATEADD(d,-60,GETDATE())\r\nGROUP BY [DatabaseName], [ObjectName], [IndexName], [Command]\r\nORDER BY [Frequency] DESC<\/pre>\n<p>This query is pretty simple, it will count the number of entries for each index that has been modified over the last 60 days and specify whether it was a REBUILD or REORGANIZE operation.<\/p>\n<p>To my surprise, I found that I had one nonclustered index that has been rebuilt 55 times in the last 60 days, and a clustered index that looks like it&#8217;s getting reorganize about every other day. \u00a0I also have a few that have regular occurrences of both rebuilds and reorganizations.<\/p>\n<p>So, by conducting a quick review of my index maintenance operations, I now know that I have a few indexes that need further investigation. \u00a0I may need to adjust some fill factors, add some filters, or just learn to live with the fact that I have indexes and tables that stay fragmented. \u00a0(Is there a support group for that?)<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of the nice things about Ola Hallengren&#8217;s maintenance solution is that it has the option to log its operations to a table. \u00a0This gives you ability to do a &#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"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":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[24,7],"tags":[10,26],"class_list":["post-277","post","type-post","status-publish","format-standard","hentry","category-indexes","category-tools","tag-database-maintenance","tag-index-basics"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Finding Recurring Index Fragmentation Issues - 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\/finding-recurring-index-fragmentation-issues\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Finding Recurring Index Fragmentation Issues - SQL Nuggets\" \/>\n<meta property=\"og:description\" content=\"One of the nice things about Ola Hallengren&#8217;s maintenance solution is that it has the option to log its operations to a table. \u00a0This gives you ability to do a ...\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.sqlnuggets.com\/finding-recurring-index-fragmentation-issues\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Nuggets\" \/>\n<meta property=\"article:published_time\" content=\"2016-11-08T22:09:09+00:00\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/finding-recurring-index-fragmentation-issues\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/finding-recurring-index-fragmentation-issues\\\/\"},\"author\":{\"name\":\"Eric Cobb\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/person\\\/210536254addbc1b9d2d95dc1448b38a\"},\"headline\":\"Finding Recurring Index Fragmentation Issues\",\"datePublished\":\"2016-11-08T22:09:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/finding-recurring-index-fragmentation-issues\\\/\"},\"wordCount\":256,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\"},\"keywords\":[\"Database Maintenance\",\"Index Basics\"],\"articleSection\":[\"Indexes\",\"Tools\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/www.sqlnuggets.com\\\/finding-recurring-index-fragmentation-issues\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/finding-recurring-index-fragmentation-issues\\\/\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/finding-recurring-index-fragmentation-issues\\\/\",\"name\":\"Finding Recurring Index Fragmentation Issues - SQL Nuggets\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#website\"},\"datePublished\":\"2016-11-08T22:09:09+00:00\",\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/finding-recurring-index-fragmentation-issues\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/www.sqlnuggets.com\\\/finding-recurring-index-fragmentation-issues\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/finding-recurring-index-fragmentation-issues\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Finding Recurring Index Fragmentation Issues\"}]},{\"@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":"Finding Recurring Index Fragmentation Issues - 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\/finding-recurring-index-fragmentation-issues\/","og_locale":"en_US","og_type":"article","og_title":"Finding Recurring Index Fragmentation Issues - SQL Nuggets","og_description":"One of the nice things about Ola Hallengren&#8217;s maintenance solution is that it has the option to log its operations to a table. \u00a0This gives you ability to do a ...","og_url":"http:\/\/www.sqlnuggets.com\/finding-recurring-index-fragmentation-issues\/","og_site_name":"SQL Nuggets","article_published_time":"2016-11-08T22:09:09+00:00","author":"Eric Cobb","twitter_card":"summary_large_image","twitter_creator":"@cfgears","twitter_site":"@sqlnugg","twitter_misc":{"Written by":"Eric Cobb","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.sqlnuggets.com\/finding-recurring-index-fragmentation-issues\/#article","isPartOf":{"@id":"http:\/\/www.sqlnuggets.com\/finding-recurring-index-fragmentation-issues\/"},"author":{"name":"Eric Cobb","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/person\/210536254addbc1b9d2d95dc1448b38a"},"headline":"Finding Recurring Index Fragmentation Issues","datePublished":"2016-11-08T22:09:09+00:00","mainEntityOfPage":{"@id":"http:\/\/www.sqlnuggets.com\/finding-recurring-index-fragmentation-issues\/"},"wordCount":256,"commentCount":0,"publisher":{"@id":"http:\/\/www.sqlnuggets.com\/#organization"},"keywords":["Database Maintenance","Index Basics"],"articleSection":["Indexes","Tools"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/www.sqlnuggets.com\/finding-recurring-index-fragmentation-issues\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/www.sqlnuggets.com\/finding-recurring-index-fragmentation-issues\/","url":"http:\/\/www.sqlnuggets.com\/finding-recurring-index-fragmentation-issues\/","name":"Finding Recurring Index Fragmentation Issues - SQL Nuggets","isPartOf":{"@id":"http:\/\/www.sqlnuggets.com\/#website"},"datePublished":"2016-11-08T22:09:09+00:00","breadcrumb":{"@id":"http:\/\/www.sqlnuggets.com\/finding-recurring-index-fragmentation-issues\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.sqlnuggets.com\/finding-recurring-index-fragmentation-issues\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/www.sqlnuggets.com\/finding-recurring-index-fragmentation-issues\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/www.sqlnuggets.com\/"},{"@type":"ListItem","position":2,"name":"Finding Recurring Index Fragmentation Issues"}]},{"@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":"","jetpack_shortlink":"https:\/\/wp.me\/pdyDvE-4t","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":449,"url":"https:\/\/sqlnuggets.com\/sql-scripts-find-index-fragmentation\/","url_meta":{"origin":277,"position":0},"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":[]},{"id":554,"url":"https:\/\/sqlnuggets.com\/index-basics-hidden-costs-associated-indexes\/","url_meta":{"origin":277,"position":1},"title":"Index Basics: Hidden Costs Associated With Indexes","author":"Eric Cobb","date":"September 26, 2017","format":false,"excerpt":"I have a confession. When I was a developer, I didn't understand indexes in SQL Server. I rarely added them to my tables, and when I did there was not really any logic behind my decision, other than it was usually just because I thought a column might be queried\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\/08\/mother-board-electronics-computer-board-39290-e1506443567415.jpeg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/08\/mother-board-electronics-computer-board-39290-e1506443567415.jpeg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/08\/mother-board-electronics-computer-board-39290-e1506443567415.jpeg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/08\/mother-board-electronics-computer-board-39290-e1506443567415.jpeg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/08\/mother-board-electronics-computer-board-39290-e1506443567415.jpeg?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":201,"url":"https:\/\/sqlnuggets.com\/index-basics-clustered-indexes\/","url_meta":{"origin":277,"position":2},"title":"Index Basics: Clustered Indexes","author":"Eric Cobb","date":"January 21, 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":468,"url":"https:\/\/sqlnuggets.com\/sql-scripts-find-index-usage\/","url_meta":{"origin":277,"position":3},"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":813,"url":"https:\/\/sqlnuggets.com\/sql-scripts-how-to-find-missing-indexes\/","url_meta":{"origin":277,"position":4},"title":"SQL Scripts: How To Find Missing Indexes","author":"Eric Cobb","date":"June 5, 2018","format":false,"excerpt":"One of the really cool things that SQL Server does is keep up with index statistics behind the scenes.\u00a0 It knows how an index has been used, how often it is used, or if it is even being used at all.\u00a0 But SQL Server doesn't just monitor the indexes that\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\/06\/lost-cat-tree-sign-fun-159868.jpeg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/06\/lost-cat-tree-sign-fun-159868.jpeg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/06\/lost-cat-tree-sign-fun-159868.jpeg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/06\/lost-cat-tree-sign-fun-159868.jpeg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/06\/lost-cat-tree-sign-fun-159868.jpeg?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":1113,"url":"https:\/\/sqlnuggets.com\/recover-deleted-indexes-with-sql-server-metrics-pack\/","url_meta":{"origin":277,"position":5},"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":[]}],"_links":{"self":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/277","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=277"}],"version-history":[{"count":0,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/277\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/media?parent=277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/categories?post=277"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/tags?post=277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}