O'Reilly logo

Professional Microsoft® SQL Server® 2008 Administration by Steven Wort, Ross LoForte, Wayne Snyder, Ketan Patel, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

15.7. Summary

This chapter started by looking at all the new index-related features in SQL Server 2008. From there we examined the details of partitioning, looking at how to set up partitioning, and covering the three main scenarios for partitioning: creating a partition from an existing table, adding a new partition, and deleting an old partition. Next we took a look at index fragmentation and how the commands for this have changed since SQL Server 2000. Finally, we looked at the Database Tuning Advisor, including comprehensive coverage of the various options and how to assess the value of the DTA's recommendations. The next chapter looks at replication.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required