SQL Server Best Practices Article
Published: November 2008Writer: Steffen KrauseContributors: Sanjay Mishra, Gopal Ashok, Greg Yvkoff, Rui WangTechnical Reviewers: Burzin Patel, Denny Lee, Glenn Berry (SQL Server MVP), Joseph Sack, Lindsey Allen, Michael Redman, Mike Ruthruff, Paul S. Randal (SQLskills.com)
Change data capture is a new feature in SQL Server 2008 that provides an easy way to capture changes to data in a set of database tables so these changes can be transferred to a second system like a data warehouse. This document provides guidance on how to configure change data capture parameters to maximize data capture performance while minimizing the performance impact on the production workload. The scope of this document is limited to the capture of change data and the cleanup process. Querying the changed data is out of scope for this white paper.
For more information, please refer to the Tuning the Performance of Change Data Capture in SQL Server 2008 whitepaper.
Nice job, Steffen!
Das Whitepaper, das ich während meiner Zeit in Redmond geschrieben habe ist erschienen (und keiner
Author: Carl Rabeler Reviewers: Mark Souza, Prem Mehra, Lindsey Allen, Mike Weiner, James Podgorski,
Pingback from Brent Ozar’s Reading List for MCM « SQL WARRIOR SPACE
Pingback from @MS_SQL_Server whitepapers New Path to Microsoft Certified Master: Microsoft SQL Server 2008 | sqlmashup
Pingback from New Path to Microsoft Certified Master: Microsoft SQL Server 2008 « SQL Consulting
In the All Good Things Come to an End - Why You Should Upgrade article we discussed some of the new features
Pingback from Top 10 Performance and Productivity Reasons to Use SQL Server 2008 for Your Business Intelligence Solutions | Developers Blog