Am I wrong in my observation about query response time on multiprocessor machines ?

Has anybody faced similar situation like this ?

Thanks Grant for taking your time to answer this post. We are facing some serious performance issues with this approach on PROD server with increasing users and data.

I think it...

While I was trying different things on query, I noticed interesting thing in execution plan. If I use CTE in my query joins, execution plan shows sort operator with cost...

Grant Fritchey (7/31/2009)

---

Is there an index in Opportunities on the AccountID? Are your indexes defragmented and the statistics up to date? How selective is the data within the Account table?

yes,...

THANK you sathappanpandian !!

--Bhimraj

About correcting IX_Path index, when I try to add two more columns it gives me warning. This index is created on TerritoryPath column which is varchar(900) field...So when I try...

Hi All,

Thank you very much for your help and taking time to look into this problem. Finally, I was able to reduce the response times for Opportunity UDF from almost...

Hi,

I updated statistics on database by using 'sp_updatestats' but it didnt help. Still simple select query to user-defined function is taking same time (apprx. 35 secs).

I noticed one change...

hello

Please refer IX_VarOffice index as IX_Office.

please find the attachments tables.txt for create table statements.

also definition of the functions fnGetTerrTree.txt and fnGetTerrTree_2.txt

Hi GilaMonster,

Please find the table-valued UDF code, Table schema and indexes in the attached zip file.

I am trying to run simple select query on the UDF function and its taking...

Actually I can not add full schema information here 🙁

Ok....Here is simple query :

...

I have uploded the execution plan below

http://www.screencast.com/t/edsAREIt

click on "Download this media." and save the file as txt , the default type is xml,

please change it to txt.

Thank you Suresh.