{"id":711,"date":"2004-07-24T05:35:59","date_gmt":"2004-07-24T05:35:59","guid":{"rendered":"\/blogs\/kimberly\/post\/MSDN-Webcast-QA-Index-Defrag-Best-Practices-Related-Resource-Questions.aspx"},"modified":"2013-01-11T23:13:58","modified_gmt":"2013-01-12T07:13:58","slug":"msdn-webcast-qa-index-defrag-best-practices-related-resource-questions","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/msdn-webcast-qa-index-defrag-best-practices-related-resource-questions\/","title":{"rendered":"MSDN Webcast Q&#038;A: Index Defrag Best Practices &#8211; Related Resource Questions"},"content":{"rendered":"<p><P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><B style=\"mso-bidi-font-weight: normal\"><FONT color=#000000><FONT face=Arial><FONT size=3>Q: Can I view a recording of this webcast?<?xml:namespace prefix = o ns = \"urn:schemas-microsoft-com:office:office\" \/><o:p><\/o:p><\/FONT><\/FONT><\/FONT><\/B><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><FONT face=Arial color=#000000 size=3>On demand MSDN webcasts (in general) can be found <\/FONT><a href=\"http:\/\/www.microsoft.com\/seminar\/events\/webcasts\/ondemand.mspx\" class=\"broken_link\"><FONT face=Arial size=3>here<\/FONT><\/a><FONT face=Arial color=#000000 size=3>. The Index Defragmentation Best Practices session is ready and available <\/FONT><a href=\"https:\/\/msevents.microsoft.com\/cui\/Error.aspx?culture=en-US&amp;ErrorMsgID=ErrorMessage.EventDoesNotExist&amp;EventID=\"><FONT face=Arial size=3>here<\/FONT><\/a><FONT face=Arial color=#000000 size=3>. The prerequisite Indexing Best Practices session (from June 11) is <\/FONT><a href=\"https:\/\/msevents.microsoft.com\/cui\/Error.aspx?culture=en-US&amp;ErrorMsgID=ErrorMessage.EventDoesNotExist&amp;EventID=\"><FONT face=Arial size=3>here<\/FONT><\/a><FONT face=Arial color=#000000 size=3>. <\/FONT><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><o:p><FONT face=Arial color=#000000 size=3>&nbsp;<\/FONT><\/o:p><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><B style=\"mso-bidi-font-weight: normal\"><FONT color=#000000><FONT face=Arial><FONT size=3>Q: Where can we get a print out of the slides?<o:p><\/o:p><\/FONT><\/FONT><\/FONT><\/B><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><FONT face=Arial color=#000000 size=3>I have posted a pdf of the presentation <\/FONT><A href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/ct.ashx?id=717be730-331f-445b-8386-b86f9e4d2af4&amp;url=http%3a\/\/3.209.169.194\/blogs\/kimberly\/content\/binary\/IndexesRightBalance-Defrag.pdf\"><FONT face=Arial size=3>here<\/FONT><\/A><FONT face=Arial color=#000000 size=3> as well as on the &#8220;Past Events&#8221; resources page on SQLskills.com <\/FONT><a href=\"https:\/\/www.sqlskills.com\/pastconferences.asp\"><FONT face=Arial size=3>here<\/FONT><\/a><FONT face=Arial color=#000000 size=3>. <\/FONT><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><o:p><FONT face=Arial color=#000000 size=3>&nbsp;<\/FONT><\/o:p><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><B style=\"mso-bidi-font-weight: normal\"><FONT color=#000000><FONT face=Arial><FONT size=3>Q: Where can we get the demo scripts?<o:p><\/o:p><\/FONT><\/FONT><\/FONT><\/B><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><FONT face=Arial color=#000000 size=3>I have posted the demo scripts here (<\/FONT><a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/permalink.aspx?guid=717be730-331f-445b-8386-b86f9e4d2af4\"><FONT face=Arial size=3>MSDNWebcast-Tripp-20040719-SCRIPTS.zip (68.37 KB)<\/FONT><\/a><FONT face=Arial color=#000000 size=3>) as well as on the &#8220;Past Events&#8221; resources page on SQLskills.com <\/FONT><a href=\"https:\/\/www.sqlskills.com\/pastconferences.asp\"><FONT face=Arial size=3>here<\/FONT><\/a><FONT face=Arial color=#000000 size=3>.<\/FONT><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><o:p><FONT face=Arial color=#000000 size=3>&nbsp;<\/FONT><\/o:p><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><B style=\"mso-bidi-font-weight: normal\"><FONT color=#000000><FONT face=Arial><FONT size=3>Q: Does <?xml:namespace prefix = st1 ns = \"urn:schemas-microsoft-com:office:smarttags\" \/><st1:PersonName w:st=\"on\">Kimberly L. Tripp<\/st1:PersonName> have a blog?<o:p><\/o:p><\/FONT><\/FONT><\/FONT><\/B><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><FONT face=Arial color=#000000 size=3>Yes, <\/FONT><a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/\"><FONT face=Arial size=3>www.SQLskills.com\/blogs\/Kimberly<\/FONT><\/a><FONT color=#000000><FONT size=3><FONT face=Arial> and if you&#8217;re reading this on my blog&#8230;well, then you already know! <\/FONT><SPAN style=\"FONT-FAMILY: Wingdings; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-char-type: symbol; mso-symbol-font-family: Wingdings\"><SPAN style=\"mso-char-type: symbol; mso-symbol-font-family: Wingdings\">J<\/SPAN><\/SPAN><\/FONT><\/FONT><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><o:p><FONT face=Arial color=#000000 size=3>&nbsp;<\/FONT><\/o:p><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><B style=\"mso-bidi-font-weight: normal\"><FONT color=#000000><FONT size=3><FONT face=Arial>Q: What&#8217;s the URL for your website (for scripts\/samples\/articles\/events?)<o:p><\/o:p><\/FONT><\/FONT><\/FONT><\/B><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><FONT face=Arial color=#000000 size=3>The main website link is: <\/FONT><A href=\"https:\/\/www.sqlskills.com\/\"><FONT face=Arial size=3>www.SQLskills.com<\/FONT><\/A><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><FONT face=Arial color=#000000 size=3>For a list of articles (many of which do NOT require a subscription), click <\/FONT><A href=\"https:\/\/www.sqlskills.com\/articles.asp\"><FONT face=Arial size=3>here<\/FONT><\/A><FONT face=Arial color=#000000 size=3>. <\/FONT><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><FONT face=Arial color=#000000 size=3>For a list of upcoming events, click <\/FONT><a href=\"https:\/\/www.sqlskills.com\/upcomingconferences.asp\"><FONT face=Arial size=3>here<\/FONT><\/a><FONT face=Arial color=#000000 size=3>.<\/FONT><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><FONT face=Arial color=#000000 size=3>For a list of past events (<I style=\"mso-bidi-font-style: normal\">including demo scripts, samples and Q&amp;As from past events<\/I>), click <\/FONT><a href=\"https:\/\/www.sqlskills.com\/pastconferences.asp\"><FONT face=Arial size=3>here<\/FONT><\/a><FONT face=Arial color=#000000 size=3>.<\/FONT><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><FONT face=Arial color=#000000 size=3>For a list of scripts (addition sample scripts not necessarily part of demo scripts), click <\/FONT><A href=\"https:\/\/www.sqlskills.com\/demoscripts.asp\"><FONT face=Arial size=3>here<\/FONT><\/A><FONT face=Arial color=#000000 size=3>. <\/FONT><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><FONT face=Arial color=#000000 size=3>For the upcoming SQLskills SQL Immersion Events (focused, intense performance tuning events), click <\/FONT><A href=\"https:\/\/www.sqlskills.com\/sqlimmersion.asp\"><FONT face=Arial size=3>here<\/FONT><\/A><FONT face=Arial color=#000000 size=3>.<\/FONT><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><o:p><FONT face=Arial color=#000000 size=3>&nbsp;<\/FONT><\/o:p><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><B style=\"mso-bidi-font-weight: normal\"><FONT color=#000000><FONT size=3><FONT face=Arial>Q: Do you speak at other events for more advanced tuning topics?<o:p><\/o:p><\/FONT><\/FONT><\/FONT><\/B><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><FONT face=Arial color=#000000 size=3>Yes, in fact, <\/FONT><A href=\"https:\/\/www.sqlskills.com\/\"><FONT face=Arial size=3>SQLskills<\/FONT><\/A><FONT face=Arial color=#000000 size=3> has a new event coming up in October that&#8217;s a 5-day event on performance tuning on SQL Server. We&#8217;re calling these events &#8220;Immersion Events&#8221; as they&#8217;re focused, indepth and intense! Full details are on <\/FONT><A href=\"https:\/\/www.sqlskills.com\/sqlimmersion.asp\"><FONT face=Arial size=3>https:\/\/www.sqlskills.com\/sqlimmersion.asp<\/FONT><\/A><FONT face=Arial color=#000000 size=3>. <\/FONT><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><o:p><FONT face=Arial color=#000000 size=3>&nbsp;<\/FONT><\/o:p><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><B style=\"mso-bidi-font-weight: normal\"><FONT color=#000000><FONT size=3><FONT face=Arial>Q: Are you available for onsite custom courses or consulting?<o:p><\/o:p><\/FONT><\/FONT><\/FONT><\/B><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><FONT face=Arial color=#000000 size=3>Yes! Feel free to email us at:<\/FONT><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt; TEXT-INDENT: 0.5in\"><A href=\"mailto:Mentoring@SQLskills.com\"><FONT face=Arial size=3>Mentoring@SQLskills.com<\/FONT><\/A><FONT face=Arial color=#000000 size=3> <\/FONT><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt; TEXT-INDENT: 0.5in\"><A href=\"mailto:CustomCourses@SQLskills.com\"><FONT face=Arial size=3>CustomCourses@SQLskills.com<\/FONT><\/A><FONT face=Arial color=#000000 size=3> <\/FONT><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt 0.5in\"><FONT color=#000000><FONT size=3><FONT face=Arial><I style=\"mso-bidi-font-style: normal\">or<\/I> feel free to email me at <\/FONT><\/FONT><\/FONT><A href=\"mailto:Kimberly@SQLskills.com\"><FONT face=Arial size=3>Kimberly@SQLskills.com<\/FONT><\/A><FONT face=Arial color=#000000 size=3> <\/FONT><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><o:p><FONT face=Arial color=#000000 size=3>&nbsp;<\/FONT><\/o:p><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><B style=\"mso-bidi-font-weight: normal\"><FONT color=#000000><FONT size=3><FONT face=Arial>Q: Can you list all of the additional resource links from the final section of the slides: <o:p><\/o:p><\/FONT><\/FONT><\/FONT><\/B><\/P><br \/>\n<UL style=\"MARGIN-TOP: 0in\" type=disc><br \/>\n<LI class=MsoNormal style=\"MARGIN: 0in 0in 0pt; COLOR: #003300; mso-list: l0 level1 lfo1; tab-stops: list .5in\"><SPAN style=\"COLOR: black; mso-bidi-font-family: Arial\"><FONT face=Arial size=3>Whitepaper: <\/FONT><a href=\"http:\/\/technet.microsoft.com\/library\/Cc966523\"><FONT face=Arial size=3>Microsoft SQL Server 2000 Index Defragmentation Best Practices<\/FONT><\/a><FONT face=Arial size=3> <\/FONT><\/SPAN><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'\"><o:p><\/o:p><\/SPAN><br \/>\n<LI class=MsoNormal style=\"MARGIN: 0in 0in 0pt; COLOR: #003300; mso-list: l0 level1 lfo1; tab-stops: list .5in\"><SPAN style=\"COLOR: black; mso-bidi-font-family: Arial\"><FONT face=Arial size=3>Whitepaper: <\/FONT><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/techart\/statquery.htm\"><FONT face=Arial size=3>Statistics Used by the Query Optimizer in Microsoft SQL Server 2000<\/FONT><\/a><\/SPAN><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'\"><o:p><\/o:p><\/SPAN><br \/>\n<LI class=MsoNormal style=\"MARGIN: 0in 0in 0pt; COLOR: #003300; mso-list: l0 level1 lfo1; tab-stops: list .5in\"><SPAN style=\"COLOR: black; mso-bidi-font-family: Arial\"><FONT face=Arial size=3>Whitepaper: <\/FONT><a href=\"http:\/\/msdn.microsoft.com\/library\/en-us\/dnsql2k\/html\/sql_queryrecompilation.asp?\"><FONT face=Arial size=3>Query Recompilation in SQL Server 2000<\/FONT><\/a><\/SPAN><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'\"><o:p><\/o:p><\/SPAN><br \/>\n<LI class=MsoNormal style=\"MARGIN: 0in 0in 0pt; COLOR: #003300; mso-list: l0 level1 lfo1; tab-stops: list .5in\"><SPAN style=\"COLOR: black; mso-bidi-font-family: Arial\"><FONT face=Arial size=3>Whitepaper: <\/FONT><a href=\"http:\/\/msdn.microsoft.com\/library\/en-us\/dnsql2k\/html\/itwforsql.asp?frame=true\"><FONT face=Arial size=3>Index Tuning Wizard for Microsoft SQL Server 2000<\/FONT><\/a><FONT face=Arial size=3> <\/FONT><\/SPAN><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'\"><o:p><\/o:p><\/SPAN><br \/>\n<LI class=MsoNormal style=\"MARGIN: 0in 0in 0pt; COLOR: #003300; mso-list: l0 level1 lfo1; tab-stops: list .5in\"><SPAN style=\"COLOR: black; mso-bidi-font-family: Arial\"><FONT face=Arial size=3>Whitepaper: <\/FONT><a href=\"http:\/\/msdn.microsoft.com\/library\/en-us\/dnsql2k\/html\/indexedviews1.asp?frame=true\"><FONT face=Arial size=3>Improving Performance with Microsoft SQL Server 2000 Indexed Views<\/FONT><\/a><\/SPAN><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'\"><o:p><\/o:p><\/SPAN><br \/>\n<LI class=MsoNormal style=\"MARGIN: 0in 0in 0pt; COLOR: black; mso-list: l0 level1 lfo1; tab-stops: list .5in\"><SPAN style=\"mso-bidi-font-family: Arial\"><FONT face=Arial size=3>Whitepaper: <\/FONT><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/techart\/partitionsindw.htm\"><FONT face=Arial size=3>Using Partitions in a Microsoft SQL Server 2000 Data Warehouse<\/FONT><\/a><FONT size=3><FONT face=Arial> <o:p><\/o:p><\/FONT><\/FONT><\/SPAN><br \/>\n<LI class=MsoNormal style=\"MARGIN: 0in 0in 0pt; COLOR: #003300; mso-list: l0 level1 lfo1; tab-stops: list .5in\"><SPAN style=\"COLOR: black; mso-bidi-font-family: Arial\"><FONT face=Arial size=3>MSDN Support WebCast: <\/FONT><a href=\"http:\/\/support.microsoft.com\/default.aspx\" class=\"broken_link\"><FONT face=Arial size=3>SQL Server 2000 Profiler: What&#8217;s New and How to Effectively Use It<\/FONT><\/a><\/SPAN><\/LI><\/UL><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Q: Can I view a recording of this webcast? On demand MSDN webcasts (in general) can be found here. The Index Defragmentation Best Practices session is ready and available here. The prerequisite Indexing Best Practices session (from June 11) is here. &nbsp; Q: Where can we get a print out of the slides? I have [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27,36,58],"tags":[],"class_list":["post-711","post","type-post","status-publish","format-standard","hentry","category-events","category-indexes","category-resources"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/711","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=711"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/711\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/media?parent=711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/categories?post=711"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/tags?post=711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}