A lot of sums

Are there indexes on Population.Postcode, Postcode_boundary.Postcode?

Depending on the uniqueness of B.CD_CODE , is there an index on Postcode_boundary.CD_CODE?

Are the statistics...

if 06/30/3003 was a typo

and date_range in the lookup table is split in 2 fields

it can be something like this

select trans_key.key_id,trans_date,Moneyfield,keylookup.good_key as corrected_key

from test.dbo.trans_key trans_key /*transaction table*/

inner join test.dbo.keylookup keylookup...

not sure if  (t1.statusid > @newstatus  or t1.statusid < @newstatus) performs better.

What are your current indexes?

Is the sql reporting server on the same server as your IIS/SQL server?

The reporting was working fine->what has changed? (Moved from development to production....?)

cheers!

Can you connect to the database using the connectionstring the application uses? (using query analyzer)

database logon failed

Is the application using windows authentication or sql authentication to connect to sql server?

try

USE mytargetdatabase

SELECT TABLE_CATALOG, TABLE_NAME

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_NAME = OBJECT_NAME(1852795252)

this site has a lot of info about repairing mdac

It mentions windows xp2 but may work as well for windows 2003 sp1

http://www.macropool.com/en/download/mdac_xp_sp2.html

any size differences between the specific database and the others?

looks you have some database corruption

http://www.mssqlcity.com/FAQ/Trouble/er605.htm

Could you post the stored procedures or the query that takes a long time to run?

Seems it could use some review.

quite late here, there is probably a better query.

IF EXISTS(SELECT *

from MeetingAttendance

WHERE MeetingID=@MeetingID

AND MeetingDate BETWEEN @StartDate AND @EndDate

)

BEGIN

    select employees.EmployeeID

    from MeetingAttendance /*AVAILABLE MEETINGS*/

    WHERE MeetingID=@MeetingID...

You can use the sql profiler to track down cpu-intensive queries.

What is the number of stored procedure recompilations/sec?

If I am reading it correctly

Employees: list of all employees

MeetingAttendance: all employees present at a meeting

Where is the reference of who needs to be present?