Sorry About that here is the code:

CREATE PROCEDURE dbo.PatientDataProvider_UpdatePatient

@patient_id INT,

@prefix VARCHAR(16),

@first_name VARCHAR(32),

@middle_name VARCHAR(32),

@last_name VARCHAR(32),

@suffix VARCHAR(16),

@address_1 VARCHAR(128) = NULL,

@address_2 VARCHAR(128) = NULL,

@city VARCHAR(32) = NULL,

@state VARCHAR(2) = NULL,

@country VARCHAR(32) = NULL,

@zip...

One of my thoughts on the indexes was to Make the Primary Key PK_Patient the Clustered index and then make the Practice_patientid index only a nonclustered index on the...

The trigger is very simple. ( I hate that we have this trigger but unfortunately not on the books to fix everywhere).

The only table involved is the Patient table....

Basically we are receiving XML from our customer and then taking that data and updating our records in multiple places. Here is the stored proc, it's really ugly.

IF EXISTS...

Here is the xml and the actual graph is attached. I put the xml into the analysis script which is how I came up with the deadlock being between...

Thanks.

I'll start there

Ok. Thanks. Just wanted to confirm. I'm trying to prevent people from restoring databases and dropping databases during business hours because it kills the plan cache. So I...

But in a ddl trigger? It doesn't look like I can but wanted to see if anyone knows better

Thanks for the responses. In terms of a computed column, I would then have to create a new column that would take the current DOB and then convert it...

Thanks. I will also take a look at the results of the code.

Actually, that might be the answer. I'll play around with it.

thanks

Yeah, that's what I was afraid of. And introducing dynamic sql is not the way I want to go.

If you try to drop a stored procedure that is part of replication you get the following error

Cannot drop the procedure 'ReportDataProvider_ArAgingSummary_New_V1' because it is being used for replication.

Can anyone help me with this?

thank You very much for the explanation. Totally makes sense. We have checked for blocking and waits. And have not seen much. We have just found...