SQL Server MVP Deep Dives
by Adam Machanic, Greg Low, Kimberly Tripp, Paul S. Randal, Kalen Delaney, Paul Nielsen
Chapter 52. Reporting Services tips and tricks
Bruce Loehle-Conger
This chapter covers performance and design tips and tricks that I’ve picked up over the years. When you’re through with the chapter, you’ll not only know how to design reports with the best possible performance, but you’ll also come away with new ways of solving problems. I guarantee that no matter how expert you are in Reporting Services (RS), you’ll find something new in this chapter.
Performance tips
The first three topics all approach optimizing performance in the same manner: limiting the amount of data that the rendering engine is working on. For good performance, limit the amount of data processed by RS. Let the database engine do what it does best and use it to retrieve ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access