As requested i have attached the execution plan, can you please check it and let me know what should be done so that bookmarks should be removed

Regards,

NAveen

Excel is attached please lookinto it

index definitin:

I_CalculatedEndTimestamp_Eventnonclustered located on PRIMARYCalculatedEndTimestamp

I1_Eventnonclustered located on PRIMARYRMType_FK, MessageType_FK, StartTimestamp

I2_Eventnonclustered located on PRIMARYStartTimestamp(-), Number_FK, MessageType_FK

PK_Eventclustered, unique, primary key located on PRIMARYEvent_PK

U1_Eventnonclustered, unique located on PRIMARYNumber_FK, StartTimestamp, CEN, RMType_FK, MessageType_FK, Floor

table...

Please find the trace of the query which i posted

SET STATISTICS PROFILE ON SQL:StmtCompleted0000

SELECT E.StartTimestamp FROM eventrelevant_v E ...

There is a view defined as below

CREATE VIEW TotalStats_FloorByFloor_v

AS

SELECT

EquipmentNumber_FK,

RemoteMonitoringType_FK,

StatisticsStartTime,

StatisticsEndTime,

starts,

door_operations,

relevellings,

door_reopenings_by_lightcurtain_cuts,

nudgings,

door_reopenings_by_safety_edge,

door_reopenings_by_unknown_reason,

bad_stops,

FloorNbr

FROM

(

SELECT

EquipmentNumber_FK,

RemoteMonitoringType_FK,

MIN(StatisticsStartTime) AS StatisticsStartTime,

MAX(StatisticsEndTime) AS...

when tried with this getting the error Incorrect syntax near '+'.

ANDMRC.CreateDate > '''+convert(varchar(20),@startdate)''' and mrc.createdate < '''+convert(varchar(20),@enddate)'''

ANDMRC.CreateDate> '+convert(varchar(20),@startdate)' and mrc.createdate< '+convert(varchar(20),@enddate)'

I tried with abovebut sillit fails

As sugested, its good to have identity column, but the design here is it is having a 2 table design. ie for events, there are 2 tables event_1 and...

when the application is tryting to call this procedure from the application, getting the below error:

failed to get next key value from stored procedure for table:Event

It looks like when something...

Thanks for your information, I dont want to change the current desing. Keeping the current design is there any way sothat blockings can be eliminated. Is it good idea to...

checked the linked servers andall running fine

Lowell, Same problem I am facing when trying to insert 1 month data I am getting duplicate records. Can you tell me how to overcome this?

Naveen

Might be we can use identity but not supposed to use this now. The code for getting next key is:

ALTER PROCEDURE [dbo].[GetNextKeyValue_p]

----------------------------------------------------------------------------------

-- Version Date: 22.03.2006

-- Copyright © 2006...

The problem I am facing is:

EventID is the primary key in the EVENT table. Whenever an event occurs, getnextkey is generated and an next eventid is generated from getnextkey...

how to clear the deadlocks, is it required to restart the sql server services or is anyother method.