Thanks Preethi For the reply How would I re-write the query to remove the OR to make the query more efficient? Also I am interested in the permanent table, this is not something I have though about Can you please give me an example of how to write different scenarios and write different SQL statements...

[quote user="techbabu303"] Translation using google tool bar hope it is right ......... [/quote] I was to do the same thing . Bye Sergio

We arrived to solving the problem , summarized in this article . Thanks to all!

I have noticed that inserting from XML is faster when using openxml and slower when using nodes(). Here is a script you can run to see the difference. The difference in performance is even more pronounced when the table is wider. Also, the execution plan for the openxml case is far simpler than for the...

Hi, I am developing an application that uses OLE DB to connect to SQL Server 2000; originally the application was using DB-Library to connect to SQL Server. To maintain compatibility with operators "=", ">=", etc. in comparison with the values NULL, I set to OFF (immediately after...

Hi, I read that writing query with filtering criteria fully qualified greatly reduces the I/O operation. So I'm changing the WHERE clause which are not fully qualified filtering, but when I examine the execution plans I do not see differences between the query with filters fully qualified and not...

review carefully the indexes and indexed views on both servers for tables,views used in that query. If the number of rows are huge different between the two servers , and update statistics recently, sometimes optimizer may change execution plan based on the expected result set, and sometimes may apply...

Hi All, I spent considerabale amount of time on tuning the following query.I tried to remove temp table with derived table,but while executing, i was getting errors. I dont have any idea about tuning on Cursors in the below query.My major concerns are, how can i replace cursors and temp tables in the...