jasona.work (10/3/2016)

---

Luis Cazares (10/3/2016)

---

jasona.work (10/3/2016)

---

Ugh...

Those of you in the US might have heard about the "creepy clowns" that seem to be popping up all over the place, especially the one...

I go from one extreme to the other. Looks like I will...

thomashohner (9/30/2016)

---

The clustered index issue is hard as these are staging tables and the method we use from change tracking is prone to duplicate inserts sometimes. Its far from ideal....

Is there one column or set of columns in PatientProfile that uniquely identifies each row of data?

If so, which column or columns?

At this point I was just wondering, no recommendations yet.

Any reason there aren't any primary keys on any of the tables? For instance, this table: Patientprofile?

Alan.B (9/30/2016)

---

Is it possible that you could post the actual execution plan instead of the estimated plan? That will tell us much more. What you posted may not be the...

Could we see the DDL including indexes for the tables?

And maybe the DDL for the tables including indexes?

Can you post the code?

Mike Scalise (9/29/2016)

---

John Mitchell-245523 (9/14/2016)

---

Mike

The log backup will only be huge if you haven't backed it up for a long time (or, more accurately, if there has been a lot...

Eric M Russell (9/29/2016)

---

Lynn Pettis (9/28/2016)

---

Pingala (9/28/2016)

---

Thanks. We implemented the RETRY to avoid deadlock. However, I am surprised how a queued DELETE got a deadlock in the first place if...

Does this help? The code is based on your sample data above, which by the way, has syntax errors I will leave for you to find and correct.

print 'Display...

Pingala (9/28/2016)

---

Thanks. We implemented the RETRY to avoid deadlock. However, I am surprised how a queued DELETE got a deadlock in the first place if SQL Server does queued operations...

andrew gothard (9/29/2016)

---

netmikem (9/28/2016)

---

I am quite sure I came across a blog or some article in the last six months mentioning that SQL Server 2014 Developer Edition is now free.

I...