C H A P T E R  8

SQL Server Relational Database

In this chapter, I’ll cover a few areas that can have a large impact on the performance of your data tier, even if you have already optimized your queries fully.

For example, our principle of minimizing round-trips also applies to round-trips between the web tier and the database. You can do that using change notifications, multiple result sets, and command batching.

The topics that I’ll cover include the following:

  • How SQL Server manages memory
  • Stored procedures
  • Command batching
  • Transactions
  • Table-valued parameters
  • Multiple result sets
  • Data precaching
  • Data access layer
  • Query and schema optimization
  • Data paging
  • Object relational models
  • XML columns
  • Data partitioning
  • Full-text search
  • Service Broker ...

Get Ultra-Fast ASP.NET 4.5 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.