Hi all, We are in the process of migrating our databases from SQL 2000 to SQL 2005, As a part of this, we figured out that there is some code which...
Hi all, We are in a process of migrating our databases from SQL server 200 to SQL server 2005. Unfortunately some of our SPs and UDFs and written in...
yes thats true. Thank you all for you valuable responses.
quote:Originally posted by joechang per above, disregard the constant scan in the execution plan for the UDF, that is not the real execution plan...
---------------- How many rows in that CMK thingy - and is it a table, or perhaps a view, or perhaps a view that fakes a table like this: SELECT...
----------------- When building query estimated execution plan and calculating cost, query optimizer doesn't take into consideration udf code. I...
Thanks for all your replies. by testing your solutions on the code, i was able to gain on the execution time by a sec or two but i am still waiting...
On the second thought, we do have an sp which calls the UDF in the way you represented
Yes I am sure
here is the UDF. As far as parameter sniffing is concerned , I don't know how far it holds true incase of UDF, all the parameter sniffing articles...
Thanks for you quick responce I tried using a local variable and passing on the value of the parameter into this local variable and using this ocal...
Hi all, We have a UDF which is returning the result in 2 seconds. When i copy the code(just two select stmts) in the UDF and hardcode the values,...
With all due respect,I know the various methods to accomplish this task. What I am interested in knowing is if there is a particular method thats...
Greetings All, I am having a SQL Server 2000 running on Windows 2000 Server(Live Production Server), now my company procured a better hardware, so I...
The average disk Que length is 6.801 (against d: drive holding the data files, which is a RAID 5 with 16 disks on it). so it comes to 0.425 /disk...
Hi all, I was monitoring the performance of our SQL SERVER using perfmonitor. The data for several counters was collected for a period of 24 hours....
Thanks Luis, Got a hold of the procedue with which i could get the max, min and avg values for the counter values. Thanks once again for your...
Hi Luis, After collecting the values of the counters in the log (with log file type = text file (CVS)), don't we have an option of displaying the...
Hi all, I was trying to capture 24 hours of performance monitor data for our SQL server in a log, Later on I intend to display the values of these...
Thanks satya for the url(s).
Separate names with a comma.
