Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Large Chunks of Data

By Steve Jones, saw a post recently where someone talked about trying to get better performance from a report. They were selecting 5mm rows from a table and wanted to see if there was a more efficient way to chunk out this data so that the instance would not report memory errors.

My first question is what kind of report has 5mm rows of data? That's just too much data.


How long can a report be?

From your experience, talking with people, looking at what they analyze, how big is a report? How much data can you really display on a report and make it useful for users?

I'm thinking here in terms of the raw data you show. A pivot table can summarize millions of records, but realistically I thin kit becomes hard to examine more than a few hundred data points on a page. Whether they are raw data or aggregates of other data, it seems there's some limit to what a report should provide.

After all, that's why we have drill-down :)

Let us know this Friday what you think; what you have observed? Maybe we'll  help others to build better reports that are more practical and useful to end users, as well as easier to develop.

Steve Jones

The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are available at You can also follow Steve Jones on Twitter:

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

Total article views: 200 | Views in the last 30 days: 2
Related Articles


A new video setup is on the way!!!! Actually I'll do a couple podcasts on podcasting over the hol...


Podcast Announcements

Podcast Feeds



I'm working on getting a small studio set up for some podcasting of the editorials. That means I put...


Podcast Problem

Podcast Problem Blocked by group policy


Podcast Upgrades

A minor change for the podcasts next week. I got my wireless microphone, and I'm working with it a b...


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones