Conclusion
Data modifications involve many challenges. You need to be familiar with SQL Server’s architecture and internals if you want to design systems that can cope with large volumes of data and large-scale modifications. Many challenging logical problems are related to data modifications, such as maintaining your own custom sequence, deleting rows with duplicate data, and assigning unique values to existing rows. In this chapter, I covered performance aspects of data modifications as well as logical ones. I also introduced the new features in SQL Server 2008 including the enhanced VALUES clause, minimal logging enhancements, the MERGE statement, and composable DML.
Get Inside Microsoft® SQL Server® 2008: T-SQL Querying now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
