Viewing 2 posts - 1 through 2 (of 2 total)
I don't see any advantage to using dynamic store procedures. Also, it would be more difficult to tune and troubleshoot dynamic stored procedures if they constantly change. In addition, data validation should...
December 16, 2005 at 7:09 am
You didn't mention Transactional Replication as a way to keep a warm standby server. It would be interesting to read about pros/cons from the field regarding this method.
October 28, 2005 at 7:31 am