Thank you very much for all your comments.

I agree application queries need to be optimized. Soon, we are going to replace this old application with a newer version by using...

I noticed that one of the application causing many Adhoc compiled plans during the working hours.

I calculated the total sum(size_in_bytes) for Adhoc compiled plans (most of them usecounts=1) from sys.dm_exec_cached_plans...

I agree it is not easy without looking at the actual code.

All Scalar functions return just a value and all table functions return one single row with calculated values.

No table...

Here is the plan.

Hi Ninja's_RGR'us,

I checked the actual plans they are line by line identical. For the indexes, some of them have %1 cost differences and that's the only difference. Sorry, I cannot...

Hi SSC-Enthusiastic,

I do reindex and update stats in both servers. [avg_fragmentation_in_percent] is for all indexes in DEV is less than 5%.

They both have the same 8 Gb RAM. Because of...

When I try to access to the remote web application, I am getting:

Server Error in '/Reports' Application.

--------------------------------------------------------------------------------

Could not load file or assembly 'ReportingServicesNativeClient' or one of its dependencies. An attempt...

Hi,

I really like the article "Parameter Sniffing & Stored Procedures Execution Plan" yet I have got the same timing result when I modify the sproc with local variable.

My guess is:

Query...

Hi Matt,

It is an interesting article thanks for the info.

/Sel

Hi Garadin,

Thank you for your message.

I investigated these two querries using "Profiler". I am getting exactly same results except the time.

I could not develop any solution.

Please let me know if...

Basicly, I need a query which will run in Server1 to call 32BitLinkedServer in Server2.

I still could not solve this problem.

Any thoughts?

OOPS,

Sorry Matt

Please ignore Step3

It is an inner join you don't need unmatching condition this time.

Hi Matt,

This is what I usually do:

1)Control Flow>Toolbox>Data Flow Task

2)

Data Flow>Toolbox>Ole DB Source1 (Connection, SQL Command from Table1)> Toolbox> Sort1 (Select the column (Table1ID) you want a match, select...

Hi Matt,

This is also useful tutorial:

Get all from Table A that isn't in Table B

http://www.sqlis.com/311.aspx