Well there you go. Pretty sure the restore process will lock the log file until you issue a with recovery statement.

Never mind the log shipping, that doesn't seem to...

Did you do a restore with NORECOVERY? Is the transaction log part of log shipping?

Is this error being caught by the calling vb.net application? Are you positive nothing on that side has been changed? Are you on different hardware now?

Darn, I wish I would have seen this earlier so I could say I helped Jeff with something SQL related...:-D

I agree with Todd, the cost percentages by themselves aren't that useful. You'll have to compare IO, cpu, and duration between the two queries with varying amounts of data...

Howard, the script I posted was designed for SQL Server 2005. Not sure if it works on 2008. I haven't tested it on a SQL Server 2008 box....

Ha! Oh man, I bet that really pissed off the PETA people...

I will take a look. Thanks.

Dev (12/21/2011)

---

bwoulfe (12/21/2011)

---

I'm familiar with the apply operator. I'll admit I don't use it too often though. I was just asking if the apply acts as...

I'm familiar with the apply operator. I'll admit I don't use it too often though. I was just asking if the apply acts as an inner join in...

I have run across similar issues in my current position. Majority of performance problems are usually traced back to a view. This has led to a no views...

Wow, big oversight on my part. I missed the part where you said this is a MySQL database. Sorry, I only have limited experience in that realm. ...

Yeah, it will only drop for that database. You'd have to do the same process in every other database. Or script the process out. If there are...

Is there a reason this can't be a SQL job that runs everyday?

Is that the same thing? Does the cross apply act as a inner join because of where OrderNumber = o.OrderNumber?