I think that I need to read something that helps me to know how to get the Execution plan, but I would like to mention that the application we use...

😉 ,

I tried that but nothing changed the same delay.

I'm not lucky with MS new technology.

Excuse me for the stupid question,

Do you mean to set the Max memory in the properities of the SQL server to lets say 1047483647 ? or let say 10000? as...

It is MS SQL Server 2008 Standard edition, and the memory setting is as defult i.e :

Minimum server memory (in MB) = 0 and Maximum server memory2147483647

Thank you for your reply, I perform all the mentioned actions and it is the same, when I try to extract a certain report on the old technology which less...

Resume Of

Samir Tawfiq Momani

 Name                             :    Samir Tawfiq Momani