chandan_jha18 (5/24/2012)

---

Lynn Pettis (5/24/2012)

---

This is the last LEFT OUTER JOIN from your view:

LEFT OUTER JOIN MOC_DT.dbo.TCN_Xref tcn

ON tcn.recid = (SELECT

MIN(recid)

...

Something more like this:

create table dbo.person(fname varchar(30), lname varchar(50), ssn varchar(11));

GO

insert into dbo.person values('John', 'Jay', '123-45-6789');

insert into dbo.person values('John', 'Doe', '123-45-6765');

insert into dbo.person values('Jane', 'Doe', '321-65-5465');

insert into dbo.person values('James', 'Smith',...

Oliiii (5/25/2012)

---

Ah, here is why you don't seem to get what i say 🙂

I'm not talking about any failure or incident. I'm only talking about mistake.

When things go right (failure...

Oliiii (5/25/2012)

---

Everyone seem to understand the opposite of what i say, i guess i suck at English :-).

We blame the application if it doesn't do it's task.

We blame the user...

For some...

When I setup mirroring at a previous employer I used event notification and Service Broker to handle the necessary processing for fail-over, including notification of interested parties (me and the...

CptCrusty1 (5/24/2012)

---

I'm not going to say your wrong. But I will say that I think the problem has been twisted and trounced that it's not even the same problem...

CptCrusty1 (5/24/2012)

---

HOLY Recursive Statement Batman!!

I just noticed that the Joins don't have the NOLOCK hint, but the views all DO have the no lock hint.... so by switching...

The mistake can come from poor development or wrong way to use the application.

By experience the mistakes comes from the way the application has been developed, they simply didn't plan...

Gullimeel (5/24/2012)

---

When the query was access the tables directly, they needed to select only the records where ISDELETED was NULL or 0, correct? Therefor the isnull(ISDELETED,0) = 0 for each...

CptCrusty1 (5/24/2012)

---

Lynn Pettis (5/24/2012)

---

Actually, you didn't eliminate the NOLOCKS hint, you just hide them in the view.

What is with the hint any way? You do know the issues with...

Gullimeel (5/24/2012)

---

Okay, lost. The view will not have any records where ISDELETED = 1. This query is having all table references changed to use views built over the tables. These...

Okay, my google-fu is in suck mode again. Anyone have links to what the effect of using NOLOCK in your queries and why you shouldn't use them? The...

Gullimeel (5/24/2012)

---

suppose one of your record has isdeleted = 1

when table will be joined... then it is decided by the joining column.Suppsoe it exists in main table as well.. Then...

My question at...