Blog cast SQL Server 2000 Performance Demo 1-1 Searching and browsing objects
Here's a Blogcast, one of a series of three from the US, looking at Performance tuning techniques with SQL 2000
https://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_1-1.asx