http://www.sqlservercentral.com/Articles tagged Programming, SQL Server 6.5 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)One of the best ways to reduce the load on your server and increase application responsiveness is to reduce the number of "round trips" your application makes. This article by Andy Warren shows you a few ways to increase your performance by reducing round trips. http://www.sqlservercentral.com/articles/Performance+Tuning/roundtrips/586/2005/07/15http://www.sqlservercentral.com/articles/Performance+Tuning/roundtrips/586/We saw a note from Chad about a tool he wrote in the forums and asked him to write up some notes. Not only did we get notes, we got the source code! See what a DBA can do with some DMO. http://www.sqlservercentral.com/articles/Administering/dumpsqlpermissions/1314/2004/03/17http://www.sqlservercentral.com/articles/Administering/dumpsqlpermissions/1314/We asked Chris to put together some information on how he uses VSS, a subject that comes up a lot as we have articles and discussions that involve change management. Change management isn't easy, you definitely need a pattern to work from. This two part article gives you a pattern you can start with and customize to your needs. http://www.sqlservercentral.com/articles/Administering/examplevssframeworksourcecodemanagementpart1/1070/2003/07/07http://www.sqlservercentral.com/articles/Administering/examplevssframeworksourcecodemanagementpart1/1070/One of the best ways to reduce the load on your server and increase application responsiveness is to reduce the number of "round trips" your application makes. This article by Andy Warren shows you a few ways to increase your performance by reducing round trips. http://www.sqlservercentral.com/articles/Performance+Tuning/roundtrips/586/2005/07/15http://www.sqlservercentral.com/articles/Performance+Tuning/roundtrips/586/This article by Andy Warren is an introduction to DSN's; what they do, how they work, and where they are stored. Also pick up some ideas about how using a File DSN might save you a lot of administration! http://www.sqlservercentral.com/articles/Configuring/20010423200421/95/2001/04/23http://www.sqlservercentral.com/articles/Configuring/20010423200421/95/