{"id":664,"date":"2005-08-26T21:43:00","date_gmt":"2005-08-26T21:43:00","guid":{"rendered":"\/blogs\/kimberly\/post\/MSDN-Webcast-QA-for-Resources-Indexing-Best-Practices-Part-4-of-10-.aspx"},"modified":"2013-01-11T23:13:47","modified_gmt":"2013-01-12T07:13:47","slug":"msdn-webcast-qa-for-resources-indexing-best-practices-part-4-of-10","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/msdn-webcast-qa-for-resources-indexing-best-practices-part-4-of-10\/","title":{"rendered":"MSDN Webcast Q&A for Resources: Indexing Best Practices, Part 4 of 10"},"content":{"rendered":"

\nEffectively Designing a Scalable and Reliable Database <\/span><\/strong>A Primer to Proper SQL Server Development<\/span><\/em><\/strong>\n<\/p>\n

\n<\/span><\/em><\/strong>Indexing Best Practices, Part 4 of 10<\/span><\/strong>\n<\/p>\n

\n<\/span><\/strong>Presented by<\/span><\/em><\/strong> Kimberly L. Tripp, SQLskills.com<\/span><\/strong>\n<\/p>\n

\n<\/span><\/strong>Q: Can I view a recording of this webcast? <\/span><\/strong>The webcast will be available for viewing within 24 hours. All “on-demand” webcasts can be found here<\/a>.<\/span>\n<\/p>\n

\n<\/span>Q: Where can we get the demo scripts AND the sample database: Credit? <\/span><\/strong>The demo scripts are in this zip (20050826MSDNDemoScripts.zip (12.17 KB)<\/a>); here in this blog entry. However, at the series completion, I will also create an entry under Past Event Resources<\/span><\/strong><\/a> for the entire webcast series. <\/span> <\/span>To download the ZIP of the Credit Database Backup click here<\/a>. Once unzipped, restore this backup to SQL Server 2000 or SQL Server 2005. The backup is a SQL Server 2000 backup and can be restored to either version! If restoring to SQL Server 2005, you might want to change the destination for the data and log file as the path will probably be different.<\/span>\n<\/p>\n

\n<\/span>Q: Where are the links to all prior Webcast Q&As from this series?<\/span><\/strong>\n<\/p>\n

\n

\n\t<\/span><\/strong>Part 1: Creating a Recoverable Database
\n\t<\/span>For the MSDN Download for Part 1, click here<\/span><\/strong><\/a>.
\n\t<\/span>For the SQLskills Blog Entry for Part 1, click here<\/span><\/strong><\/a>.<\/span>\n\t<\/p>\n

\n\t<\/span>Part 2: Creating a Reliable and Automated Backup Strategy
\n\t<\/span>For the MSDN Download for Part 2, click here<\/span><\/strong><\/a>.
\n\t<\/span>For the SQLskills Blog Entry for Part 2, click here<\/span><\/strong><\/a>.<\/span>\n\t<\/p>\n

\n\t<\/span>Part 3: Designing Tables that Scale, Best Practices in Data Types and Initial Table Structures
\n\t<\/span>For the MSDN Download for Part 3, click here<\/span><\/strong><\/a>.
\n\t<\/span>For the SQLskills Blog Entry for Part 3, click here<\/span><\/strong><\/a>.<\/span>\n\t<\/p>\n<\/blockquote>\n

\n<\/span>Q: How can I replay previous sessions? I thought we were going to get emails for replaying — but I haven't received any replay emails. <\/span><\/strong>You will receive replay emails ONLY when you register for these sessions through MSDN. We’ve come to find out that there are other ways to register but it’s only through MSDN that we know for sure you will receive the replay information. Regardless, you can always find the “on-demand” version of the sessions here<\/span><\/strong><\/a>.<\/span>\n<\/p>\n

\n<\/span>Resources mentioned in today’s Session:<\/span><\/strong>\n<\/p>\n

\n<\/span><\/strong>If you’re interested in hearing more of the theory behind the indexing recommednations, as well as more of the reasoning behind unique, narrow and static criteria for the clustering key –  <\/span>watch 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". I<\/span>f you’re interested in hearing a lot more about how to use Profiler effectively with ITW, watch 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.<\/span>\n<\/p>\n

\n<\/span>\n<\/p>\n

\nAs for whitepapers:<\/strong><\/span>\n<\/p>\n

\n

\n\tSQL Server 2005 Beta II Whitepaper: Partitioned Tables and Indexes<\/a> by Kimberly L. Tripp<\/span><\/span>\n\t<\/p>\n

\n\t<\/span><\/span>\n\t<\/p>\n

\n\tSQL Server 2005 Beta II Whitepaper: Snapshot Isolation<\/a> by Kimberly L. Tripp<\/span><\/span><\/span>\n\t<\/p>\n

\n\t<\/span><\/span><\/span>\n\t<\/p>\n

\n\tPREVIEW: The Database Administrator’s Guide to the SQL Server Database Engine .NET Common Language Runtime Environment<\/a> by Kimberly L. Tripp<\/span><\/span><\/span>\n\t<\/p>\n

\n\t<\/span><\/span><\/span>\n\t<\/p>\n

\n\tImproving Performance with SQL Server 2005 Indexed Views<\/a> by Author: Eric Hanson and Contributors: Gail Erickson, Lubor Kollar, Jason Ward<\/span><\/span><\/span>\n\t<\/p>\n

\n\t<\/span><\/span><\/span>\n\t<\/p>\n

\n\tImproving Performance with SQL Server 2000 Indexed Views<\/a> by Author: Gail Erickson and Contributors: Lubor Kollar, Jason Ward contributor<\/span><\/span><\/span> 
\n\t<\/span><\/span>\n\t<\/p>\n<\/blockquote>\n

\nAdditional Webcasts:<\/strong><\/span><\/span>\n<\/p>\n

\n\tTechNet Webcast: Performance Diagnosis in SQL Server 2005 (Level 300)<\/a><\/span> by Vipul Shah<\/span> <\/p>\n

\n\t<\/span>\n\t<\/p>\n

\tTechNet Webcast: SQL Server 2005 Database Tuning Advisor (Level 300)<\/a> by Vipul Shah<\/span> <\/span>Support WebCast: SQL Server 2000 Profiler: What's New and How to Effectively Use It<\/a> by Sri Kasam and Ajay Manchepalli<\/span> <\/span>TechNet Support WebCast: I\/O performance problems and resolutions in Microsoft SQL Server 2000<\/a> by David G. Brown<\/span> <\/span>TechNet Webcast: SQL Server 2005 Series (Part 7 of 10): Indexing Enhancements (Level 200)<\/a> By Bryan Von Axelson<\/span>\n<\/p><\/blockquote>\n

<\/span><\/p>\n

\nSummary!<\/strong><\/span>\n<\/p>\n

Finally, check out the Indexes category<\/a> on my blog – for a variety of Q&A postings, other resources and lots of great links!<\/a><\/span> <\/span>The rest of the technical Q&A, I should be able to post soon. Stay tuned!<\/span> <\/span>Thanks,<\/span>kt<\/span> <\/p>\n","protected":false},"excerpt":{"rendered":"

Effectively Designing a Scalable and Reliable Database A Primer to Proper SQL Server Development Indexing Best Practices, Part 4 of 10 Presented by Kimberly L. Tripp, SQLskills.com Q: Can I view a recording of this webcast? The webcast will be available for viewing within 24 hours. All “on-demand” webcasts can be found here. Q: Where […]<\/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-664","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\/664","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=664"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/664\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/media?parent=664"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/categories?post=664"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/tags?post=664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}