http://www.sqlservercentral.com/Articles tagged Programming, SQL Server 6.5, SQL Server 7, 2000 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/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/