Online Index Tuning eLearning - Training Resources
Index Tuning Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
SQL Server 7 0 - Implementing a Database - Part 2

...fill non-leaf level pages. Identify the functions of the Index Tuning wizard. Select the methods of managing data fragmentation. Perform the steps to display the base table size and fragmentation. Select when to use the DBCC DBREINDEX statement. Select the methods available to manually update the index statistics. Identify the information the SHOWPLAN statements return when executed.
more...
SQL Server 7 0 - Implementing a Database - Part 2
From Teach Me IT
Optimizing an SQL 7.0 Data Warehouse

The Optimizing an SQL 7.0 Data Warehouse is the fourth course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. This curriculum prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019) exam. It helps students to identify tasks for data warehouse maintenance and optimization. The students will be able to optimize query
more...
