{"id":666,"date":"2005-08-25T15:43:00","date_gmt":"2005-08-25T15:43:00","guid":{"rendered":"\/blogs\/kimberly\/post\/Getting-ready-for-Part-4-Best-Practices-in-Indexing-in-the-MSDN-Webcast-Series-on-Effectively-Designing-a-Scalable-and-Reliable-Database.aspx"},"modified":"2013-01-11T23:12:57","modified_gmt":"2013-01-12T07:12:57","slug":"getting-ready-for-part-4-best-practices-in-indexing-in-the-msdn-webcast-series-on-effectively-designing-a-scalable-and-reliable-database","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/getting-ready-for-part-4-best-practices-in-indexing-in-the-msdn-webcast-series-on-effectively-designing-a-scalable-and-reliable-database\/","title":{"rendered":"Getting ready for Part 4, “Best Practices in Indexing” in the MSDN Webcast Series on Effectively Designing a Scalable and Reliable Database"},"content":{"rendered":"

\nTwo days isn't enough time!<\/strong>\n<\/p>\n

\nIn fact, that's really true. There are so many interesting (well, I think they're interesting<\/em>) aspects to Indexing that we could in fact do a whole 10-part Series on Indexing and it's likely that we'd still have other things to look at and talk about. So, in preparation for part 4 of my MSDN Webcast Series, I thought I'd take a few minutes to pull together a number of related resources. If you watch\/read them prior to the webcast then you'll be a step ahead. To minimize overlap, part 4 is a myriad of best practices with more of the "what's" and "how's" to implement the right indexes – but not quite as much of the theory and\/or the "why's" as I've done quite a bit of that before and even if you don't watch\/read these resources BEFORE the session…you can use these resources to fill in the gaps and answers the "why's" AFTER the session!\n<\/p>\n

\nSo, let's talk about the session… I'm going to focus on SQL Server 2005 for all of my demos (and I'm going to try to be VERY demo heavy in this one<\/em>) but quite a bit of the theory also applies to SQL Server 2000…\n<\/p>\n

\nIf you're interested in some of the "why's" and\/or you want to hear the information for SQL Server 2000 and\/or you just want to see what other folks have asked, here are your options:\n<\/p>\n

\nWatch the MSDN Webcast titled: SQL Server 2000: Performance Tuning – Finding the Right Balance of Indexes<\/a> which covers Index Creation Best Practices on SQL Server 2000<\/strong>
\nWatch the TechNet "It's Showtime" recording, recorded at Tech Ed Europe titled: Index Creation Best Practices with SQL Server 2005<\/a> which covers Index Creation Best Practices on SQL Server 2005 and really gets into a lot of the "why's"\n<\/p>\n

\nRead many of the past blog entries – including A LOT of Q&As created from former webcasts by accessing my "Indexes" category on my blog entries here<\/a>.\n<\/p>\n

\nSo, if you're not scared to spend quite a bit of time with indexes… I think there's lots of good stuff to review! At a minimum you should think about showing up tomorrow, I promise to give you Practical Indexing Strategies and a lot of demos to prove my point!\n<\/p>\n

\nEffectively Designing a Scalable and Reliable Database
\n<\/span><\/strong>A Database Developer’s Primer to Proper SQL Server Development
\n<\/span><\/em>Part 4: Best Practices in Indexing<\/strong><\/span>\n<\/p>\n

\nAttend Part 4 LIVE on 26 August 2005 by registering at this link!<\/a><\/strong><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Two days isn't enough time! In fact, that's really true. There are so many interesting (well, I think they're interesting) aspects to Indexing that we could in fact do a whole 10-part Series on Indexing and it's likely that we'd still have other things to look at and talk about. So, in preparation for part […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25,27,36,47,49,58,65,78],"tags":[],"class_list":["post-666","post","type-post","status-publish","format-standard","hentry","category-design","category-events","category-indexes","category-msdn-webcasts","category-opinions","category-resources","category-sql-server-2005","category-tips"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/666","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/comments?post=666"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/666\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/media?parent=666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/categories?post=666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/tags?post=666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}