{"id":728,"date":"2004-06-12T22:15:26","date_gmt":"2004-06-12T22:15:26","guid":{"rendered":"\/blogs\/kimberly\/post\/MSDN-Webcast-SQL-Index-Tuning-QA-Related-Resources.aspx"},"modified":"2013-01-11T23:14:08","modified_gmt":"2013-01-12T07:14:08","slug":"msdn-webcast-sql-index-tuning-qa-related-resources","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/msdn-webcast-sql-index-tuning-qa-related-resources\/","title":{"rendered":"MSDN Webcast SQL Index Tuning Q&#038;A: Related Resources"},"content":{"rendered":"<p><P><STRONG><FONT size=4>Related Resources:<\/FONT><\/STRONG><\/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: 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>It should be available on <\/FONT><a href=\"http:\/\/www.microsoft.com\/seminar\/events\/webcasts\/ondemand.mspx\" class=\"broken_link\"><FONT face=Arial size=3>www.microsoft.com\/usa\/webcasts\/ondemand<\/FONT><\/a><FONT face=Arial color=#000000 size=3> shortly.<\/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 powerpoint file?<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 powerpoint will be available on the MSDN webcast resource page. I will post the exact link here and on SQLskills.com as soon as the final link is available.<\/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>The demo scripts will also be available on the MSDN webcast resource page but since it&#8217;s a small file I will also place them here <a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/content\/binary\/msdnwebcast-tripp-20040611-scripts.zip\"><FONT face=Verdana size=2>MSDNWebcast-Tripp-20040611-SCRIPTS.zip (73.19 KB)<\/FONT><\/a>. Additionally, you can find the scripts on <\/FONT><A href=\"https:\/\/www.sqlskills.com\/\"><FONT face=Arial size=3>www.SQLskills.com<\/FONT><\/A><FONT face=Arial color=#000000 size=3> under Event resources.<\/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: Where can we get BPA &#8211; the Best Practices Analyzer?<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 BPA is on the front page <\/FONT><a href=\"http:\/\/www.microsoft.com\/sqlserver\/en\/us\/default.aspx\"><FONT face=Arial size=3>http:\/\/www.microsoft.com\/sql<\/FONT><\/a><FONT face=Arial color=#000000 size=3> and the download is specifically <a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=15691\" class=\"broken_link\">here<\/a><\/FONT><FONT face=Arial color=#000000 size=3>. <\/FONT><\/P><br \/>\n<P class=MsoNormal style=\"MARGIN: 0in 0in 0pt\"><B style=\"mso-bidi-font-weight: normal\"><o:p><FONT face=Arial color=#000000 size=3>&nbsp;<\/FONT><\/o:p><\/B><\/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 recommend a good source for information on optimizing full-text indexes and searches?<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>Start with the Books Online topic:&nbsp;<a href=\"http:\/\/msdn.microsoft.com\/library\/default.asp?url=\/library\/en-us\/architec\/8_ar_sa2_0ehx.asp\">Full-text Query Architecture<\/a><\/FONT><FONT face=Arial color=#000000 size=3>&nbsp;and then make sure to check out this MSDN article by Andrew B. Cencini titled: <a href=\"http:\/\/msdn.microsoft.com\/library\/en-us\/dnsql2k\/html\/sql_fulltextsearch.asp?frame=true\">Building Search Applications for the Web Using Microsoft SQL Server 2000 Full-Text Search<\/a><\/FONT><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 in 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, SQLskills has a new event coming up in October that&#8217;s a 5-day event on performance tuning on SQL Server. We&#8217;ve just announced this event in June and for those of you who become subscribers on SQLskills and sign up by July 1<SUP>st<\/SUP> you&#8217;ll receive the lowest early bird cost for the event. 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\/\"><FONT face=Arial size=3>www.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\"><FONT face=Arial color=#000000 size=3>Finally, here are all of the resource links I recommended in the resources section of the slides:<\/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<UL style=\"MARGIN-TOP: 0in\" type=disc><br \/>\n<LI class=MsoNormal style=\"MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in\"><FONT face=Arial color=#000000 size=3>Whitepaper: <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/techart\/statquery.htm\">Statistics Used by the Query Optimizer in Microsoft SQL Server 2000<\/a><\/FONT><br \/>\n<LI class=MsoNormal style=\"MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in\"><FONT face=Arial color=#000000 size=3>Whitepaper: <a href=\"http:\/\/msdn.microsoft.com\/library\/en-us\/dnsql2k\/html\/sql_queryrecompilation.asp?\">Query Recompilation in SQL Server 2000<\/a><\/FONT><br \/>\n<LI class=MsoNormal style=\"MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in\"><FONT face=Arial color=#000000 size=3>Whitepaper: <a href=\"http:\/\/msdn.microsoft.com\/library\/en-us\/dnsql2k\/html\/itwforsql.asp?frame=true\">Index Tuning Wizard for Microsoft SQL Server 2000<\/a><\/FONT><FONT face=Arial color=#000000 size=3> <\/FONT><br \/>\n<LI class=MsoNormal style=\"MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in\"><FONT face=Arial color=#000000 size=3>Whitepaper: <a href=\"http:\/\/msdn.microsoft.com\/library\/en-us\/dnsql2k\/html\/indexedviews1.asp?frame=true\">Improving Performance with Microsoft SQL Server 2000 Indexed Views<\/a><\/FONT><br \/>\n<LI class=MsoNormal style=\"MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in\"><FONT color=#000000><FONT size=3><FONT face=Arial>Whitepaper: <a href=\"http:\/\/technet.microsoft.com\/library\/Cc966523\">Microsoft SQL Server 2000 Index Defragmentation Best Practices<\/a><\/FONT><\/FONT><\/FONT><FONT face=Arial color=#000000 size=3> <\/FONT><br \/>\n<LI class=MsoNormal style=\"MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in\"><FONT face=Arial color=#000000 size=3>Whitepaper: <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/techart\/partitionsindw.htm\">Using Partitions in a Microsoft SQL Server 2000 Data Warehouse<\/a><\/FONT><FONT color=#000000><FONT size=3><FONT face=Arial> <o:p><\/o:p><\/FONT><\/FONT><\/FONT><br \/>\n<LI class=MsoNormal style=\"MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in\"><FONT face=Arial color=#000000 size=3>MSDN Support WebCast: <a href=\"http:\/\/support.microsoft.com\/default.aspx\" class=\"broken_link\">SQL Server 2000 Profiler: What&#8217;s New and How to Effectively Use It<\/a><\/FONT><\/LI><\/UL><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><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Related Resources: Q: Can I view a recording of this webcast? It should be available on www.microsoft.com\/usa\/webcasts\/ondemand shortly. &nbsp; Q: Where can we get the powerpoint file? The powerpoint will be available on the MSDN webcast resource page. I will post the exact link here and on SQLskills.com as soon as the final link is [&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,78],"tags":[],"class_list":["post-728","post","type-post","status-publish","format-standard","hentry","category-events","category-indexes","category-resources","category-tips"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/728","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=728"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/728\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/media?parent=728"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/categories?post=728"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/tags?post=728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}