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?

Since there are only 4 possible diagnostic codes

You could create a view using left joins

select  groupedvid.v_id,

from

(SELECT DISTINCT v_id

FROM dbo.mydiagnose mydiagnose

) AS groupedvid

INNER JOIN

(select  l_id,c_id,v_id,createdate,moddate

FROM dbo.mydiagnose mydiagnose

) AS visitinfo

on...

odd issue

What version of query analyzer are you using? (see Help->About)

sql server 2000 sp1 mentions a fix

Query Analyzer Hangs After You Drag && Drop Files Into the Query Editor and...

60% of the improvement can normally found in the application itself,how it handles its data and general design of your database (3NF?)

If possible, check what has changed in the application....

Is there any parallellism in the query plans?

If the cpu is sleeping it could be an I/O issue.

just a sidequestion: why don't you name the object owner?

something from the books online (pivot table)

SELECT togroupby,

    SUM(CASE Group WHEN 1 THEN Amount ELSE 0 END) AS A,

    SUM(CASE Group WHEN 2 THEN Amount ELSE 0 END) AS...

The resore keeps blowing up -> any reported error?

Is the server OS windows 2003 or client OS windows XP SP2?

sure sp_blockinglocks is written alright? (can't find it in the books online)

probably

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q237398&

The "Cannot start transaction while in firehose mode" error occurs when an OLE-DB provider attempts to perform a join transaction with results pending and while not in an...

With enterprise manager you can create scheduled jobs for sql agent.

(management->Sql Agent->Jobs->Create)

Sql Agent then runs it at the specified time.

Perhaps this:

http://www.dbforums.com/archive/index.php/t-958605.html

Have you tried uninstalling and than reinstalling the client components tools of sql server?