Looks like this thread is not active, but did not find another one. I did a direct upgrade and the upgrade and gave me errors that rsctr.dll is being used...

Thanks a lot!!!

Can someone please help me extracting the below one?

<Return>

<SOURCE PROCESSSTATECODE="30" ERRORCODE="4835" FORMNAME="26" FIELDNAME="">

<DEST MESSAGE_ID="10289">

<MSG> If some investment is...

Thanks Steve! But, the storage vendor (they are the #1 in the world to say) says they didnt see any queing or blocking on the disk side; neither did we...

I just happened to face this issue. I have been facing cpu increase, blocks etc and nailed down to Checkpoint blocking Log backups. MS supplied a job that collects blocking...

Rajan John-243593 (3/29/2010)

---

How can I check the execution plan of a query that is run from the application? Also, I know that ARITHABORT is ON in SQL Server and OFF...

Can you please sent me the link to the post you answered this? Thanks in advance!

RBarry..I didnt see if you already replied to this in another post. Can you please provide me the post link? Thabnks in advance!

How can I check the execution plan of a query that is run from the application? Also, I know that ARITHABORT is ON in SQL Server and OFF in ADO.NET...

Thanks Gail!!

Thanks! It makes sense. But, I am trying to understand why there should be big blockage due to this. Id the app getting the data to the remote machine which...

also, will running profiler remotely pull trace data to the remote machine and then push back to the server to write on the server? Any help is appreciated!

apart from performance benefits, it is likely that if someone else adds an additional column, there will be problems in the application because it returns more columns than desired.

there are some known issues with parallelism. go through this post - http://blogs.msdn.com/sqlcat/archive/2005/11/30/498415.aspx

http://rajanjohn.blogspot.com

douglascfast (9/9/2008)

---

Did I miss something? If two columns are 1 in lengh, and the others are 9 "some text" and 14 "Some more text", then would not the count(*)...