Some Practical Database Access Tips

   

The following is a brief summary of some common strategies that will provide high-performance, scalable data access for your enterprise application.

For More Information   For more information on data modeling, designing data structures, and determining data attributes, see Designing Enterprise Data in Chapter 4 of this book.

For More Information   For more information using cursors in your application, see Choosing and Managing Cursors in Chapter 7 of this book.

For More Information   For more information on configuring SQL Server packet sizes, search online for "Setting the Configuration Options" and "Network Tuning" in MSDN Library Visual Studio 6.0.

For More Information   For more information on the benefits of connection pooling, see Using Connection Pooling in this chapter.