O'Reilly logo

Ultra-Fast ASP.NET 4.5 by Richard Kiessig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required