I hope this is the correct place to ask. I am running SQL server 2008 with a large database. The 3rd party software that connects to the database is giving me this error when i try to get Reports (time and attendance) etc from it. Could this be a server side error as i doubt it is the software.
It used to work if i just ask for 1 week or 2weeks worth of data but anything bigger i get this error from the 3rd party software -----The number of records for this report is too large, use filters to reduce size ------
Yes , but anything more than 2 weeks it gives the error. It is a well known access control system so it would be weird that it cant load lets say 6 months worth of data, they use it in the pentagon and at microsoft and they have a lot of employees.
If you are trying to “get everything from forever” from the database only to filter some data out of the result set, i.e. you are not using nor do you need all of the data, you have a few options that I can think of.
if you are SELECTing * - don’t, SELECT only what you need
as Dave posted, include a WHERE condition in the query, if not dates, some other criteria. (eg. not null, location, first initial of last name ??)
aggregate eg. COUNT(attendance), SUM(time)
You may be able to tweak up the memory / time limits of whatever is processing the result set. IMHO abusing resource use is generally Not A Good Idea ™ but for a one off job during lull time it might be acceptable.
I have spoken to the supplier of the software and they indicate i have a Ram issue (Not having enough( they recommend tripple the amount. does it make sense that Ram would help for running the reports. it used to work but as i mentioned the database grew 100 fold
