Hi Scott,

Thank for share this interesting rules. I was not knowing that!

I came from Oracle SQL, and these NULL things, works different.

Thank you again.

Hi Jeffrey,

It was my mistake. The column name is po_num and not ponum.

thank you.

Hi Scott

Your solution worked like a charm!

Thank you.

Hi Jonathan,

Yes. My mistake. I wrote  ponum instead of po_num.

But the problem persists.

Thank you.

Hi,

Independen for the brand, I believe that we everyone are chasing the best performance available. And that performance includes hardware and software. That´s why we seeing brands like Apple, ruling...

Hi,

If the behaivour stops after a while, I believe that is a transaction issue. I will should check temp db in order to see if there is plenty of space....

Yes indeed, linux is nothing on the desktop environment. Lack of drivers and uncompatibility to run applications is the big deal to adopt this powerfull OS. But in the servers...

Hi

As all the other replies, it seems like a classic bad cardinallity problem. I might add to update statistics, to check the execution plan. Perhaps you have more than one...

Hi,
Dealing with deadlocks is allways different on each case.
I recommend you to strat to analyze the execution plan of the querys involved.
Usually, a change on the select statement, tunning or...

Hi

"If SQL is running on a Windows 2008 R2 server or cluster, go to the Performance Monitor application, expand the Data Collection Sets, then select the System Performance,...

Hi,
In early days of ERP boom, in one of the companies where I worked, ended with an Informix DB running on HP-HA disk array with RAID 5 enabled. We...

Hi,
I started my carrer as a tech support staff. Then I started to have another duties like server admin, pbx admin, developer, dba, project manager, erp admin, security admin,...

Hi,
In my case, I deploy both: db changes and also code changes. To handle this, we schedule a fame window where the db and the app will not be...

Hi,
the reazon why you have two execution plans different, basically, for the same query is due to the server interprets the query as different, even if they performance...

Hi,
The short answer is yes. Assuming that every of your DR procedures works well. In my experience, if you are confident with the san discs replication as the whole...