and Indexes on as well as the indexes on the tables CM.dbo.tblEncounters and CM.dbo.tblCharge?

is CM.dbo.tblEncounters = ECounter (Non Clustered Index)

CM.dbo.tblCharge = Enc (Non Clustered Index)

The Store Procedure "MyStoreProcedure" has 19 Pages hard to post here ( I hope you understand). Some time this SP work fine and Some time i am getting Dead Lock...

Here it is...

Date,Source,Severity,Message

01/07/2013 15:56:32,spid26s,Unknown,deadlock-list

01/07/2013 15:56:32,spid26s,Unknown,deadlock victim=process253f8c5dc8

01/07/2013 15:56:32,spid26s,Unknown,process-list

01/07/2013 15:56:32,spid26s,Unknown,process id=process253f8c5dc8 taskpriority=0 logused=0 waitresource=PAGE: 7:1:2772944 waittime=986 ownerId=2832471083 transactionname=INSERT lasttranstarted=2013-01-07T15:56:10.547 XDES=0x21d3d0ea70 lockMode=S schedulerid=26 kpid=12768 status=suspended spid=102 sbid=0 ecid=0 priority=0 trancount=0 lastbatchstarted=2013-01-07T15:56:10.547 lastbatchcompleted=2013-01-07T15:53:14.657 clientapp=Microsoft...

Thanks,

I checked Error Log, and they create Lot of new entries. You want me to Paste everything (all 22 rows or any specific one?)

Thanks for your prompt reply.

I ran DBCC TRACEON(1222,-1)

Message:-

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

I couldn't see any Graph. Help me out..

Thank You.

Thank You for Look into it. Yes it is TYPO Mistake...

Please any advise would be great appreciate!

Point to Master.

Hi Guys,

Thank you so much to give me answer in detialll...

Appreciate all.

Have a nice weekend!

Gila I am 100% agree with you, Due to time issue it is really hard for us to go that path, Yes for feature we have to

use that path...

Good questions,

Our application is sometime is very slow and user complain.

First step I took = Index Fregmentation (its help alot)

Second Step i am doing few table that i...

I am trying to run below query

select

DB_NAME(database_id) as "database_name"

, OBJECT_NAME(object_id, database_id) as "procedure_name"

, last_execution_time

from

sys.dm_exec_procedure_stats

WHERE DB_NAME(database_id) = 'MYDB'

ORDER BY last_execution_time DESC

Question = Which time i am receving "...

Thanks for help guys,

Its a 18 Pages S.P, its hard for me to through all logic here, that's what i want

LEFT OUTER JOIN Information_Sales A on A.SID = Case...

OMG I AM SO SORRYYYYY, I totally forgot there is page 2nd. I just implement your code its work fine, Again i am so

sorry for this Confusion and Great Appreciate.

Good...

Hi Guys,

Here again, This Cursor and Procedure runs fine with no Problem, if i schedule in morning around 5:30am.

Now i have question is how i can receive everyday...

Once again thanks and i understand what you saying, Here is the PROBLEM.

I can't convert or paste my store procedure here (8 Pages S.P) lot of logic involve....

If i run...