Related Resources:
Q: Can I view a recording of this webcast?
It should be available on www.microsoft.com/usa/webcasts/ondemand shortly.
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 available.
Q: Where can we get the demo scripts?
The demo scripts will also be available on the MSDN webcast resource page but since it’s a small file I will also place them here MSDNWebcast-Tripp-20040611-SCRIPTS.zip (73.19 KB). Additionally, you can find the scripts on www.SQLskills.com under Event resources.
Q: Where can we get BPA – the Best Practices Analyzer?
The BPA is on the front page http://www.microsoft.com/sql and the download is specifically here.
Q: Can you recommend a good source for information on optimizing full-text indexes and searches?
Start with the Books Online topic: Full-text Query Architecture and then make sure to check out this MSDN article by Andrew B. Cencini titled: Building Search Applications for the Web Using Microsoft SQL Server 2000 Full-Text Search.
Q: Do you speak in other events for more advanced tuning topics?
Yes, in fact, SQLskills has a new event coming up in October that’s a 5-day event on performance tuning on SQL Server. We’ve just announced this event in June and for those of you who become subscribers on SQLskills and sign up by July 1st you’ll receive the lowest early bird cost for the event. We’re calling these events “Immersion Events” as they’re focused, indepth and intense! Full details are on www.SQLskills.com.
Finally, here are all of the resource links I recommended in the resources section of the slides:
- Whitepaper: Statistics Used by the Query Optimizer in Microsoft SQL Server 2000
- Whitepaper: Query Recompilation in SQL Server 2000
- Whitepaper: Index Tuning Wizard for Microsoft SQL Server 2000
- Whitepaper: Improving Performance with Microsoft SQL Server 2000 Indexed Views
- Whitepaper: Microsoft SQL Server 2000 Index Defragmentation Best Practices
- Whitepaper: Using Partitions in a Microsoft SQL Server 2000 Data Warehouse
- MSDN Support WebCast: SQL Server 2000 Profiler: What’s New and How to Effectively Use It
Q: Does
Yes, www.SQLskills.com/blogs/Kimberly and if you’re reading this on my blog…well, then you already know! J