{"id":1664,"date":"2013-04-12T12:00:19","date_gmt":"2013-04-12T16:00:19","guid":{"rendered":"http:\/\/sqlity.net\/en\/?p=1664"},"modified":"2014-11-13T15:23:38","modified_gmt":"2014-11-13T20:23:38","slug":"presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know","status":"publish","type":"post","link":"https:\/\/sqlity.net\/en\/1664\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\/","title":{"rendered":"Presentation Materials: 15 Aspects of SQL Server Indexes that You Might Not Know"},"content":{"rendered":"<div>\n<h3>Abstract<\/h3>\n<p>\nYou probably know that indexes make you queries faster. But do you know why? Knowing how the different index types work under the covers will help you make the right decisions when (re-)designing you indexing strategy.\n<\/p>\n<p>\nAfter attending this demo rich session you will be able to<\/p>\n<ul>\n<li>Explain the differences between SQL Servers 9 \"index\" types<\/li>\n<li>Identify the layout of SQL Server data on disk<\/li>\n<li>Decide which index types are the right ones to use for a given query<\/li>\n<li>Assess the impact of the Key on access speed<\/li>\n<\/ul>\n<h3>Prerequisites<\/h3>\n<p>\nTo get the most out of this talk, you should feel comfortable writing multi-table queries. You also should know the basic indexing  terminology.\n<\/p>\n<h3>Materials<\/h3>\n<p>\n<a href=\"http:\/\/downloads.sqlity.net\/15AspectsOfIndexes.pdf\">Slides<\/a>\n<\/p>\n<h3>Feedback<\/h3>\n<p>\n<a href=\"https:\/\/docs.google.com\/forms\/d\/1SB_cPrDI75rcxsv-btIw_KgbwIHhG3cFGR93dP6hHek\/viewform\">Feedback Form for Attendees<\/a>\n<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Abstract You probably know that indexes make you queries faster. But do you know why? Knowing how the different index types work under the covers will help you make the right decisions when (re-)designing you indexing strategy. After attending this <a href=\"https:\/\/sqlity.net\/en\/1664\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\/\">[more&#8230;]<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_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},"jetpack_post_was_ever_published":false},"categories":[11],"tags":[],"class_list":["post-1664","post","type-post","status-publish","format-standard","hentry","category-presentations"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Presentation Materials: 15 Aspects of SQL Server Indexes that You Might Not Know - sqlity.net<\/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:\/\/sqlity.net\/en\/1664\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Presentation Materials: 15 Aspects of SQL Server Indexes that You Might Not Know - sqlity.net\" \/>\n<meta property=\"og:description\" content=\"Abstract You probably know that indexes make you queries faster. But do you know why? Knowing how the different index types work under the covers will help you make the right decisions when (re-)designing you indexing strategy. After attending this [more...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sqlity.net\/en\/1664\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\/\" \/>\n<meta property=\"og:site_name\" content=\"sqlity.net\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/sqlity.net\" \/>\n<meta property=\"article:published_time\" content=\"2013-04-12T16:00:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-11-13T20:23:38+00:00\" \/>\n<meta name=\"author\" content=\"Sebastian Meine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sqlity\" \/>\n<meta name=\"twitter:site\" content=\"@sqlity\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sebastian Meine\" \/>\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\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1664\\\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1664\\\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\\\/\"},\"author\":{\"name\":\"Sebastian Meine\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"headline\":\"Presentation Materials: 15 Aspects of SQL Server Indexes that You Might Not Know\",\"datePublished\":\"2013-04-12T16:00:19+00:00\",\"dateModified\":\"2014-11-13T20:23:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1664\\\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\\\/\"},\"wordCount\":132,\"commentCount\":1,\"articleSection\":[\"Presentations\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/1664\\\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1664\\\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\\\/\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1664\\\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\\\/\",\"name\":\"Presentation Materials: 15 Aspects of SQL Server Indexes that You Might Not Know - sqlity.net\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\"},\"datePublished\":\"2013-04-12T16:00:19+00:00\",\"dateModified\":\"2014-11-13T20:23:38+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1664\\\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/1664\\\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1664\\\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Presentation Materials: 15 Aspects of SQL Server Indexes that You Might Not Know\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\",\"name\":\"sqlity.net\",\"description\":\"Quality for SQL\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sqlity.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\",\"name\":\"Sebastian Meine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"caption\":\"Sebastian Meine\"},\"sameAs\":[\"http:\\\/\\\/sqlity.net\",\"https:\\\/\\\/x.com\\\/sqlity\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Presentation Materials: 15 Aspects of SQL Server Indexes that You Might Not Know - sqlity.net","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:\/\/sqlity.net\/en\/1664\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\/","og_locale":"en_US","og_type":"article","og_title":"Presentation Materials: 15 Aspects of SQL Server Indexes that You Might Not Know - sqlity.net","og_description":"Abstract You probably know that indexes make you queries faster. But do you know why? Knowing how the different index types work under the covers will help you make the right decisions when (re-)designing you indexing strategy. After attending this [more...]","og_url":"https:\/\/sqlity.net\/en\/1664\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\/","og_site_name":"sqlity.net","article_publisher":"https:\/\/www.facebook.com\/sqlity.net","article_published_time":"2013-04-12T16:00:19+00:00","article_modified_time":"2014-11-13T20:23:38+00:00","author":"Sebastian Meine","twitter_card":"summary_large_image","twitter_creator":"@sqlity","twitter_site":"@sqlity","twitter_misc":{"Written by":"Sebastian Meine","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sqlity.net\/en\/1664\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\/#article","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/1664\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\/"},"author":{"name":"Sebastian Meine","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"headline":"Presentation Materials: 15 Aspects of SQL Server Indexes that You Might Not Know","datePublished":"2013-04-12T16:00:19+00:00","dateModified":"2014-11-13T20:23:38+00:00","mainEntityOfPage":{"@id":"https:\/\/sqlity.net\/en\/1664\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\/"},"wordCount":132,"commentCount":1,"articleSection":["Presentations"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sqlity.net\/en\/1664\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sqlity.net\/en\/1664\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\/","url":"https:\/\/sqlity.net\/en\/1664\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\/","name":"Presentation Materials: 15 Aspects of SQL Server Indexes that You Might Not Know - sqlity.net","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/#website"},"datePublished":"2013-04-12T16:00:19+00:00","dateModified":"2014-11-13T20:23:38+00:00","author":{"@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"breadcrumb":{"@id":"https:\/\/sqlity.net\/en\/1664\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sqlity.net\/en\/1664\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/sqlity.net\/en\/1664\/presentation-materials-15-aspects-of-sql-server-indexes-that-you-might-not-know\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sqlity.net\/en\/"},{"@type":"ListItem","position":2,"name":"Presentation Materials: 15 Aspects of SQL Server Indexes that You Might Not Know"}]},{"@type":"WebSite","@id":"https:\/\/sqlity.net\/en\/#website","url":"https:\/\/sqlity.net\/en\/","name":"sqlity.net","description":"Quality for SQL","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sqlity.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c","name":"Sebastian Meine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","caption":"Sebastian Meine"},"sameAs":["http:\/\/sqlity.net","https:\/\/x.com\/sqlity"]}]}},"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2wXuw-qQ","jetpack-related-posts":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/1664","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/comments?post=1664"}],"version-history":[{"count":0,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/1664\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/media?parent=1664"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/categories?post=1664"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/tags?post=1664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}