Cowboy DBA (6/21/2013)

---

Assuming I've understood what you're on about you might have to do your delete as:

DELETE FROM dbo.cart C

LEFT OUTER JOIN

...

Cowboy DBA (6/21/2013)

---

This help?

WHEN NOT MATCHED BY SOURCE AND

...

Apologies I probably didn't make my self clear, the query wasn't hanging but was taking an age to execute to the point i would stop the query.

I think it was...

bugg (6/21/2013)

---

No its not getting blocked its on my dev SQL database.

However I've just spotted...

No its not getting blocked its on my dev SQL database.

However I've just spotted that...

Looks like this happened at same time as the index rebuild under the same spid.

Has anyone else seen this before, that can perhaps provide a little more insight?

Thanks

email-935809 (8/10/2010)

---

I've noticed some blocking sessions caused by the following SQL but it's nowhere to be found in my SP's and Exe's. Anyone know what this is? Is...

Michael Valentine Jones (4/19/2013)

---

Since you are getting deadlocks between a select and an update, you can probably eliminate the problem by setting the database to use row version isolation (Read...

ChrisM@Work (4/2/2013)

---

The SELECT query is no longer using index IX_suspect_status_rsn_shipopt, it's now using IX_sessionID, same as the UDATE query, because of the changes made in the last iteration. Using IX_sessionID,...

NJDave (4/19/2013)

---

Hello - I need to approve a SQL disk configuration - I know it is best to put data, logs and tempdb on seperate drives but not sure how...

ChrisM@Work (3/25/2013)

---

OK got it. You need to change two indexes.

1. Include orderhash and status in index IX_SessionID, like this:

CREATE NONCLUSTERED INDEX [IX_sessionid] ON [dbo].[orderha]

([sessionid] ASC, OrderHash ASC) INCLUDE (Status)...

Thanks Gila, had to look up sargable...

bugg (3/25/2013)

---

ChrisM@Work (3/25/2013)

---

OK got it. You need to change two indexes.

1. Include orderhash and status in index IX_SessionID, like this:

CREATE NONCLUSTERED INDEX [IX_sessionid] ON [dbo].[orderha]

([sessionid] ASC, OrderHash ASC) INCLUDE...

ChrisM@Work (3/25/2013)

---

OK got it. You need to change two indexes.

1. Include orderhash and status in index IX_SessionID, like this:

CREATE NONCLUSTERED INDEX [IX_sessionid] ON [dbo].[orderha]

([sessionid] ASC, OrderHash ASC) INCLUDE (Status)...

ChrisM@Work (3/25/2013)

---

This article linked in my sig explains in detail how to post execution plans. They're active - .png graphics are not.

Right-click on the execution plan tab, select "Save...