{"id":958,"date":"2009-01-29T02:10:00","date_gmt":"2009-01-29T02:10:00","guid":{"rendered":"\/blogs\/paul\/post\/Coming-up-fast-SQL-Connections-Spring-2009-indexes!.aspx"},"modified":"2017-04-13T11:40:31","modified_gmt":"2017-04-13T18:40:31","slug":"coming-up-fast-sql-connections-spring-2009-indexes","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/coming-up-fast-sql-connections-spring-2009-indexes\/","title":{"rendered":"Coming up fast: SQL Connections Spring 2009 &#8211; indexes!"},"content":{"rendered":"<p><span style=\"font-family: verdana, geneva; font-size: small;\">This year it looks like we&#8217;re not going to be involved in TechEd US\u00a0in May so the <\/span><span style=\"font-family: verdana, geneva; font-size: small;\">SQL Connections show in Orlando in March (21-26)<\/span><span style=\"font-family: verdana, geneva; font-size: small;\"> will be the best way to pick up some of our training in the first half of the year. We are planning to do some Immersion events in various locations around the world (including the US) in the second half of 2009, so watch the blog for announcements.<\/span><\/p>\n<p><span style=\"font-family: verdana, geneva; font-size: small;\">Anyway, at this Connections Kimberly and I are going all-out on indexes &#8211; here&#8217;s what we&#8217;ve got planned:<\/span><\/p>\n<ul>\n<li>\n<div><span style=\"font-family: verdana, geneva; font-size: small;\">A\u00a0full-day pre-con workshop on index internals, statistics, and fragmentation (2000, 2005, 2008)<\/span><\/div>\n<\/li>\n<li>\n<div><span style=\"font-family: verdana, geneva; font-size: small;\">A full-day post-con workshop on analyzing your indexing strategy &#8211; looking for extra, missing, or unhealthy indexes and dealing with them (2000, 2005, 2008)<\/span><\/div>\n<\/li>\n<li>\n<div><span style=\"font-family: verdana, geneva; font-size: small;\">A session by Kimberly on tuning indexes for various search arguments, joins, and aggregates (i.e. indexing for performance)<\/span><\/div>\n<\/li>\n<li>\n<div><span style=\"font-family: verdana, geneva; font-size: small;\">A session by Kimberly on sparse columns and filtered indexes in SQL Server 2008<\/span><\/div>\n<\/li>\n<\/ul>\n<p><span style=\"font-family: verdana, geneva; font-size: small;\">And apart from indexing-mania, we&#8217;ll have sessions on surviving database corruption and effective database maintenance. Our plan is to have AS LITTLE OVERLAP AS POSSIBLE between all these sessions and workshops &#8211; that&#8217;s a lot of material!<\/span><\/p>\n<p><span style=\"font-family: verdana, geneva; font-size: small;\">Of course, <a href=\"https:\/\/www.sqlskills.com\/aboutbobbeauchemin.asp\">Bob Beauchemin<\/a> will be there with a plethora of developer-centric topics (including a full-day pre-pre-con on spatial data) and a bunch of other top SQL speakers that we&#8217;ve pulled together to create a great show.<\/span><\/p>\n<p><span style=\"font-family: verdana, geneva; font-size: small;\">Checkout out our\u00a0<a href=\"https:\/\/www.sqlskills.com\/upcomingconferences.asp\">Upcoming Events<\/a> page for all the abstracts and details on how to register.<\/span><\/p>\n<p><span style=\"font-family: verdana, geneva; font-size: small;\">Hope to see you there!<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This year it looks like we&#8217;re not going to be involved in TechEd US\u00a0in May so the SQL Connections show in Orlando in March (21-26) will be the best way to pick up some of our training in the first half of the year. We are planning to do some Immersion events in various locations [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24,27],"tags":[],"class_list":["post-958","post","type-post","status-publish","format-standard","hentry","category-classes","category-conferences"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Coming up fast: SQL Connections Spring 2009 - indexes! - Paul S. Randal<\/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\/paul\/coming-up-fast-sql-connections-spring-2009-indexes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Coming up fast: SQL Connections Spring 2009 - indexes! - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"This year it looks like we&#8217;re not going to be involved in TechEd US\u00a0in May so the SQL Connections show in Orlando in March (21-26) will be the best way to pick up some of our training in the first half of the year. We are planning to do some Immersion events in various locations [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/coming-up-fast-sql-connections-spring-2009-indexes\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2009-01-29T02:10:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T18:40:31+00:00\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/coming-up-fast-sql-connections-spring-2009-indexes\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/coming-up-fast-sql-connections-spring-2009-indexes\/\",\"name\":\"Coming up fast: SQL Connections Spring 2009 - indexes! - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2009-01-29T02:10:00+00:00\",\"dateModified\":\"2017-04-13T18:40:31+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/coming-up-fast-sql-connections-spring-2009-indexes\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/coming-up-fast-sql-connections-spring-2009-indexes\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/coming-up-fast-sql-connections-spring-2009-indexes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Coming up fast: SQL Connections Spring 2009 &#8211; indexes!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Coming up fast: SQL Connections Spring 2009 - indexes! - Paul S. Randal","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\/paul\/coming-up-fast-sql-connections-spring-2009-indexes\/","og_locale":"en_US","og_type":"article","og_title":"Coming up fast: SQL Connections Spring 2009 - indexes! - Paul S. Randal","og_description":"This year it looks like we&#8217;re not going to be involved in TechEd US\u00a0in May so the SQL Connections show in Orlando in March (21-26) will be the best way to pick up some of our training in the first half of the year. We are planning to do some Immersion events in various locations [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/coming-up-fast-sql-connections-spring-2009-indexes\/","og_site_name":"Paul S. Randal","article_published_time":"2009-01-29T02:10:00+00:00","article_modified_time":"2017-04-13T18:40:31+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/coming-up-fast-sql-connections-spring-2009-indexes\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/coming-up-fast-sql-connections-spring-2009-indexes\/","name":"Coming up fast: SQL Connections Spring 2009 - indexes! - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2009-01-29T02:10:00+00:00","dateModified":"2017-04-13T18:40:31+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/coming-up-fast-sql-connections-spring-2009-indexes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/coming-up-fast-sql-connections-spring-2009-indexes\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/coming-up-fast-sql-connections-spring-2009-indexes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"Coming up fast: SQL Connections Spring 2009 &#8211; indexes!"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/958","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=958"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/958\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}