Welcome to MSDN Blogs Sign in | Join | Help

March 2006 - Posts

Managing Schema Changes (Part 2)
SQLCAT Blog: Managing Schema Changes (Part 2) Question: What are best practices for managing schema changes in SQL Server 2005? What are the fastest, least intrusive techniques for high availability? Answer: In Part 1, we outlined the behavior of SQL Read More...
2. Application Patterns and database performance: Academically correct object modeling.
Another pattern that can cause too many round trips to the database is when each object is treated as a black box and is responsible for retrieving and saving its own data. This by itself is not the problem; it’s when the object hierarchy reaches three Read More...
Managing Schema Changes (Part 1)
Question: What are best practices for managing schema changes in SQL Server 2005? What are the fastest, least intrusive techniques for high availability? Answer: A common requirement as business requirements evolve over time is managing schema changes. Read More...
Page view tracker