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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial