Real integral using residue theorem - why doesn't this work? The Next CEO of Stack OverflowMistake with using residue theory for calculating $int_-infty^inftyfracsin(x)xdx$Evaluating Integral with Residue TheoremReal Pole Residue theoremSolving this complicated integral using the Residue TheoremIntegrating secans over the imaginary axis using the residue theoremWhy doesn't this residue method work for calculating $sum_k=1^k=infty fraccos(k x)k^2$Compute integral using residue theoremEvaluating a real definite integral using residue theoremCalculating this integral using Residue TheoremCalculating integrals using the residue theoremsolving integral with real exponent and real pole with residue theorem

Multi tool use
Multi tool use

Why do professional authors make "consistency" mistakes? And how to avoid them?

What flight has the highest ratio of time difference to flight time?

Example of a Mathematician/Physicist whose Other Publications during their PhD eclipsed their PhD Thesis

To not tell, not take, and not want

If/When UK leaves the EU, can a future goverment conduct a referendum to join the EU?

Why do we use the plural of movies in this phrase "We went to the movies last night."?

How does the Z80 determine which peripheral sent an interrupt?

Is 'diverse range' a pleonastic phrase?

What was the first Unix version to run on a microcomputer?

If the heap is initialized for security, then why is the stack uninitialized?

Why do airplanes bank sharply to the right after air-to-air refueling?

Is there an analogue of projective spaces for proper schemes?

What benefits would be gained by using human laborers instead of drones in deep sea mining?

What does convergence in distribution "in the Gromov–Hausdorff" sense mean?

How to count occurrences of text in a file?

Which tube will fit a -(700 x 25c) wheel?

Elegant way to replace substring in a regex with optional groups in Python?

How to avoid supervisors with prejudiced views?

Why do remote companies require working in the US?

Why is the US ranked as #45 in Press Freedom ratings, despite its extremely permissive free speech laws?

Is micro rebar a better way to reinforce concrete than rebar?

Do I need to enable Dev Hub in my PROD Org?

What happened in Rome, when the western empire "fell"?

Can you replace a racial trait cantrip when leveling up?



Real integral using residue theorem - why doesn't this work?



The Next CEO of Stack OverflowMistake with using residue theory for calculating $int_-infty^inftyfracsin(x)xdx$Evaluating Integral with Residue TheoremReal Pole Residue theoremSolving this complicated integral using the Residue TheoremIntegrating secans over the imaginary axis using the residue theoremWhy doesn't this residue method work for calculating $sum_k=1^k=infty fraccos(k x)k^2$Compute integral using residue theoremEvaluating a real definite integral using residue theoremCalculating this integral using Residue TheoremCalculating integrals using the residue theoremsolving integral with real exponent and real pole with residue theorem










2












$begingroup$


Consider the following definite real integral:
$$I = int_0^infty dx frace^-ix - e^ixx$$



Using the $textSi(x)$ function, I can solve it easily,
$$I = -2i int_0^infty dx frace^-ix - e^ix-2ix = -2i int_0^infty dx fracsinxx = -2i lim_x to infty textSi(x) = -2i left(fracpi2right) = - i pi,$$
simply because I happen to know that $mathrmSi(x)$ asymptotically approaches $pi/2$.



However, if I try to calculate it using the residue theorem, I get the wrong answer, off by a factor of $2$ and I'm not sure if I understand why. Here's the procedure:
$$I= int_0^infty dx frace^-ixx - int_0^infty dx frac e^ixx = colorred-int_-infty^0 dx frace^ixx - int_0^infty dx frac e^ixx
= -int_-infty^infty dx frace^ixx $$

Then I define $$I_epsilon := -int_-infty^infty dx frace^ixx-ivarepsilon$$ for $varepsilon > 0$ so that$$I=lim_varepsilon to 0^+ I_varepsilon.$$
Then I complexify the integration variable and integrate over a D-shaped contour over the upper half of the complex plane. I choose that contour because
$$lim_x to +iinfty frace^ixx-ivarepsilon = 0$$ and it contains the simple pole at $x_0 = i varepsilon$. Using the residue theorem with the contour enclosing $x_0$ $$I_varepsilon = -2 pi i , textRes_x_0 left( frace^ixx-ivarepsilonright) = -2 pi i left( frace^ix1 right)Biggrvert_x=x_0=ivarepsilon=-2 pi i , e^-varepsilon.$$
Therefore,
$$I=lim_varepsilon to 0^+ left( -2 pi i , e^-varepsilon right) = -2pi i.$$



However, that is obviously wrong. Where exactly is the mistake?










share|cite|improve this question









$endgroup$







  • 1




    $begingroup$
    math.stackexchange.com/a/2270510/155436
    $endgroup$
    – Count Iblis
    4 hours ago










  • $begingroup$
    @CountIblis Didn't catch that one before, thank you!
    $endgroup$
    – Ivan V.
    4 hours ago















2












$begingroup$


Consider the following definite real integral:
$$I = int_0^infty dx frace^-ix - e^ixx$$



Using the $textSi(x)$ function, I can solve it easily,
$$I = -2i int_0^infty dx frace^-ix - e^ix-2ix = -2i int_0^infty dx fracsinxx = -2i lim_x to infty textSi(x) = -2i left(fracpi2right) = - i pi,$$
simply because I happen to know that $mathrmSi(x)$ asymptotically approaches $pi/2$.



However, if I try to calculate it using the residue theorem, I get the wrong answer, off by a factor of $2$ and I'm not sure if I understand why. Here's the procedure:
$$I= int_0^infty dx frace^-ixx - int_0^infty dx frac e^ixx = colorred-int_-infty^0 dx frace^ixx - int_0^infty dx frac e^ixx
= -int_-infty^infty dx frace^ixx $$

Then I define $$I_epsilon := -int_-infty^infty dx frace^ixx-ivarepsilon$$ for $varepsilon > 0$ so that$$I=lim_varepsilon to 0^+ I_varepsilon.$$
Then I complexify the integration variable and integrate over a D-shaped contour over the upper half of the complex plane. I choose that contour because
$$lim_x to +iinfty frace^ixx-ivarepsilon = 0$$ and it contains the simple pole at $x_0 = i varepsilon$. Using the residue theorem with the contour enclosing $x_0$ $$I_varepsilon = -2 pi i , textRes_x_0 left( frace^ixx-ivarepsilonright) = -2 pi i left( frace^ix1 right)Biggrvert_x=x_0=ivarepsilon=-2 pi i , e^-varepsilon.$$
Therefore,
$$I=lim_varepsilon to 0^+ left( -2 pi i , e^-varepsilon right) = -2pi i.$$



However, that is obviously wrong. Where exactly is the mistake?










share|cite|improve this question









$endgroup$







  • 1




    $begingroup$
    math.stackexchange.com/a/2270510/155436
    $endgroup$
    – Count Iblis
    4 hours ago










  • $begingroup$
    @CountIblis Didn't catch that one before, thank you!
    $endgroup$
    – Ivan V.
    4 hours ago













2












2








2





$begingroup$


Consider the following definite real integral:
$$I = int_0^infty dx frace^-ix - e^ixx$$



Using the $textSi(x)$ function, I can solve it easily,
$$I = -2i int_0^infty dx frace^-ix - e^ix-2ix = -2i int_0^infty dx fracsinxx = -2i lim_x to infty textSi(x) = -2i left(fracpi2right) = - i pi,$$
simply because I happen to know that $mathrmSi(x)$ asymptotically approaches $pi/2$.



However, if I try to calculate it using the residue theorem, I get the wrong answer, off by a factor of $2$ and I'm not sure if I understand why. Here's the procedure:
$$I= int_0^infty dx frace^-ixx - int_0^infty dx frac e^ixx = colorred-int_-infty^0 dx frace^ixx - int_0^infty dx frac e^ixx
= -int_-infty^infty dx frace^ixx $$

Then I define $$I_epsilon := -int_-infty^infty dx frace^ixx-ivarepsilon$$ for $varepsilon > 0$ so that$$I=lim_varepsilon to 0^+ I_varepsilon.$$
Then I complexify the integration variable and integrate over a D-shaped contour over the upper half of the complex plane. I choose that contour because
$$lim_x to +iinfty frace^ixx-ivarepsilon = 0$$ and it contains the simple pole at $x_0 = i varepsilon$. Using the residue theorem with the contour enclosing $x_0$ $$I_varepsilon = -2 pi i , textRes_x_0 left( frace^ixx-ivarepsilonright) = -2 pi i left( frace^ix1 right)Biggrvert_x=x_0=ivarepsilon=-2 pi i , e^-varepsilon.$$
Therefore,
$$I=lim_varepsilon to 0^+ left( -2 pi i , e^-varepsilon right) = -2pi i.$$



However, that is obviously wrong. Where exactly is the mistake?










share|cite|improve this question









$endgroup$




Consider the following definite real integral:
$$I = int_0^infty dx frace^-ix - e^ixx$$



Using the $textSi(x)$ function, I can solve it easily,
$$I = -2i int_0^infty dx frace^-ix - e^ix-2ix = -2i int_0^infty dx fracsinxx = -2i lim_x to infty textSi(x) = -2i left(fracpi2right) = - i pi,$$
simply because I happen to know that $mathrmSi(x)$ asymptotically approaches $pi/2$.



However, if I try to calculate it using the residue theorem, I get the wrong answer, off by a factor of $2$ and I'm not sure if I understand why. Here's the procedure:
$$I= int_0^infty dx frace^-ixx - int_0^infty dx frac e^ixx = colorred-int_-infty^0 dx frace^ixx - int_0^infty dx frac e^ixx
= -int_-infty^infty dx frace^ixx $$

Then I define $$I_epsilon := -int_-infty^infty dx frace^ixx-ivarepsilon$$ for $varepsilon > 0$ so that$$I=lim_varepsilon to 0^+ I_varepsilon.$$
Then I complexify the integration variable and integrate over a D-shaped contour over the upper half of the complex plane. I choose that contour because
$$lim_x to +iinfty frace^ixx-ivarepsilon = 0$$ and it contains the simple pole at $x_0 = i varepsilon$. Using the residue theorem with the contour enclosing $x_0$ $$I_varepsilon = -2 pi i , textRes_x_0 left( frace^ixx-ivarepsilonright) = -2 pi i left( frace^ix1 right)Biggrvert_x=x_0=ivarepsilon=-2 pi i , e^-varepsilon.$$
Therefore,
$$I=lim_varepsilon to 0^+ left( -2 pi i , e^-varepsilon right) = -2pi i.$$



However, that is obviously wrong. Where exactly is the mistake?







integration residue-calculus






share|cite|improve this question













share|cite|improve this question











share|cite|improve this question




share|cite|improve this question










asked 5 hours ago









Ivan V.Ivan V.

811216




811216







  • 1




    $begingroup$
    math.stackexchange.com/a/2270510/155436
    $endgroup$
    – Count Iblis
    4 hours ago










  • $begingroup$
    @CountIblis Didn't catch that one before, thank you!
    $endgroup$
    – Ivan V.
    4 hours ago












  • 1




    $begingroup$
    math.stackexchange.com/a/2270510/155436
    $endgroup$
    – Count Iblis
    4 hours ago










  • $begingroup$
    @CountIblis Didn't catch that one before, thank you!
    $endgroup$
    – Ivan V.
    4 hours ago







1




1




$begingroup$
math.stackexchange.com/a/2270510/155436
$endgroup$
– Count Iblis
4 hours ago




$begingroup$
math.stackexchange.com/a/2270510/155436
$endgroup$
– Count Iblis
4 hours ago












$begingroup$
@CountIblis Didn't catch that one before, thank you!
$endgroup$
– Ivan V.
4 hours ago




$begingroup$
@CountIblis Didn't catch that one before, thank you!
$endgroup$
– Ivan V.
4 hours ago










3 Answers
3






active

oldest

votes


















3












$begingroup$

You've replaced the converging integral $int_0^infty fracmathrme^-mathrmi x - mathrme^mathrmi xx ,mathrmdx$ with two divergent integrals, $int_0^infty fracmathrme^-mathrmi xx ,mathrmdx$ and $int_0^infty fracmathrme^mathrmi xx ,mathrmdx$. (That something divergent has been introduced is evident in your need to sneak up on a singularity at $0$ that was not in the original integral.)



Also, notice that your D-shaped contour does not go around your freshly minted singularity at $x = 0$. The singularity lands on your contour. See the Sokhotski–Plemelj theorem to find that the multiplier for the residue of the pole is $pm pi mathrmi$, not $pm 2 pi mathrmi$.






share|cite|improve this answer









$endgroup$












  • $begingroup$
    Ah, of course! And thank you for the additional info, very useful.
    $endgroup$
    – Ivan V.
    4 hours ago


















2












$begingroup$

You cannot shift the pole from the integration contour at will. Imagine that you shift it in the lower complex half-plane. Then instead of $-2pi i$ you would obtain for the integral the value $0$!



The correct way to handle the pole is to take the half of its residue value, which is equivalent to bypassing the pole along a tiny semicircle around it (observe that the result does not depend on the choice between upper and lower semicircle).






share|cite|improve this answer











$endgroup$




















    0












    $begingroup$

    There is a problem at the very first step. You cannot split the integral because both integrals are divergent.






    share|cite|improve this answer









    $endgroup$













      Your Answer





      StackExchange.ifUsing("editor", function ()
      return StackExchange.using("mathjaxEditing", function ()
      StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix)
      StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
      );
      );
      , "mathjax-editing");

      StackExchange.ready(function()
      var channelOptions =
      tags: "".split(" "),
      id: "69"
      ;
      initTagRenderer("".split(" "), "".split(" "), channelOptions);

      StackExchange.using("externalEditor", function()
      // Have to fire editor after snippets, if snippets enabled
      if (StackExchange.settings.snippets.snippetsEnabled)
      StackExchange.using("snippets", function()
      createEditor();
      );

      else
      createEditor();

      );

      function createEditor()
      StackExchange.prepareEditor(
      heartbeatType: 'answer',
      autoActivateHeartbeat: false,
      convertImagesToLinks: true,
      noModals: true,
      showLowRepImageUploadWarning: true,
      reputationToPostImages: 10,
      bindNavPrevention: true,
      postfix: "",
      imageUploader:
      brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
      contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
      allowUrls: true
      ,
      noCode: true, onDemand: true,
      discardSelector: ".discard-answer"
      ,immediatelyShowMarkdownHelp:true
      );



      );













      draft saved

      draft discarded


















      StackExchange.ready(
      function ()
      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f3167734%2freal-integral-using-residue-theorem-why-doesnt-this-work%23new-answer', 'question_page');

      );

      Post as a guest















      Required, but never shown

























      3 Answers
      3






      active

      oldest

      votes








      3 Answers
      3






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes









      3












      $begingroup$

      You've replaced the converging integral $int_0^infty fracmathrme^-mathrmi x - mathrme^mathrmi xx ,mathrmdx$ with two divergent integrals, $int_0^infty fracmathrme^-mathrmi xx ,mathrmdx$ and $int_0^infty fracmathrme^mathrmi xx ,mathrmdx$. (That something divergent has been introduced is evident in your need to sneak up on a singularity at $0$ that was not in the original integral.)



      Also, notice that your D-shaped contour does not go around your freshly minted singularity at $x = 0$. The singularity lands on your contour. See the Sokhotski–Plemelj theorem to find that the multiplier for the residue of the pole is $pm pi mathrmi$, not $pm 2 pi mathrmi$.






      share|cite|improve this answer









      $endgroup$












      • $begingroup$
        Ah, of course! And thank you for the additional info, very useful.
        $endgroup$
        – Ivan V.
        4 hours ago















      3












      $begingroup$

      You've replaced the converging integral $int_0^infty fracmathrme^-mathrmi x - mathrme^mathrmi xx ,mathrmdx$ with two divergent integrals, $int_0^infty fracmathrme^-mathrmi xx ,mathrmdx$ and $int_0^infty fracmathrme^mathrmi xx ,mathrmdx$. (That something divergent has been introduced is evident in your need to sneak up on a singularity at $0$ that was not in the original integral.)



      Also, notice that your D-shaped contour does not go around your freshly minted singularity at $x = 0$. The singularity lands on your contour. See the Sokhotski–Plemelj theorem to find that the multiplier for the residue of the pole is $pm pi mathrmi$, not $pm 2 pi mathrmi$.






      share|cite|improve this answer









      $endgroup$












      • $begingroup$
        Ah, of course! And thank you for the additional info, very useful.
        $endgroup$
        – Ivan V.
        4 hours ago













      3












      3








      3





      $begingroup$

      You've replaced the converging integral $int_0^infty fracmathrme^-mathrmi x - mathrme^mathrmi xx ,mathrmdx$ with two divergent integrals, $int_0^infty fracmathrme^-mathrmi xx ,mathrmdx$ and $int_0^infty fracmathrme^mathrmi xx ,mathrmdx$. (That something divergent has been introduced is evident in your need to sneak up on a singularity at $0$ that was not in the original integral.)



      Also, notice that your D-shaped contour does not go around your freshly minted singularity at $x = 0$. The singularity lands on your contour. See the Sokhotski–Plemelj theorem to find that the multiplier for the residue of the pole is $pm pi mathrmi$, not $pm 2 pi mathrmi$.






      share|cite|improve this answer









      $endgroup$



      You've replaced the converging integral $int_0^infty fracmathrme^-mathrmi x - mathrme^mathrmi xx ,mathrmdx$ with two divergent integrals, $int_0^infty fracmathrme^-mathrmi xx ,mathrmdx$ and $int_0^infty fracmathrme^mathrmi xx ,mathrmdx$. (That something divergent has been introduced is evident in your need to sneak up on a singularity at $0$ that was not in the original integral.)



      Also, notice that your D-shaped contour does not go around your freshly minted singularity at $x = 0$. The singularity lands on your contour. See the Sokhotski–Plemelj theorem to find that the multiplier for the residue of the pole is $pm pi mathrmi$, not $pm 2 pi mathrmi$.







      share|cite|improve this answer












      share|cite|improve this answer



      share|cite|improve this answer










      answered 4 hours ago









      Eric TowersEric Towers

      33.3k22370




      33.3k22370











      • $begingroup$
        Ah, of course! And thank you for the additional info, very useful.
        $endgroup$
        – Ivan V.
        4 hours ago
















      • $begingroup$
        Ah, of course! And thank you for the additional info, very useful.
        $endgroup$
        – Ivan V.
        4 hours ago















      $begingroup$
      Ah, of course! And thank you for the additional info, very useful.
      $endgroup$
      – Ivan V.
      4 hours ago




      $begingroup$
      Ah, of course! And thank you for the additional info, very useful.
      $endgroup$
      – Ivan V.
      4 hours ago











      2












      $begingroup$

      You cannot shift the pole from the integration contour at will. Imagine that you shift it in the lower complex half-plane. Then instead of $-2pi i$ you would obtain for the integral the value $0$!



      The correct way to handle the pole is to take the half of its residue value, which is equivalent to bypassing the pole along a tiny semicircle around it (observe that the result does not depend on the choice between upper and lower semicircle).






      share|cite|improve this answer











      $endgroup$

















        2












        $begingroup$

        You cannot shift the pole from the integration contour at will. Imagine that you shift it in the lower complex half-plane. Then instead of $-2pi i$ you would obtain for the integral the value $0$!



        The correct way to handle the pole is to take the half of its residue value, which is equivalent to bypassing the pole along a tiny semicircle around it (observe that the result does not depend on the choice between upper and lower semicircle).






        share|cite|improve this answer











        $endgroup$















          2












          2








          2





          $begingroup$

          You cannot shift the pole from the integration contour at will. Imagine that you shift it in the lower complex half-plane. Then instead of $-2pi i$ you would obtain for the integral the value $0$!



          The correct way to handle the pole is to take the half of its residue value, which is equivalent to bypassing the pole along a tiny semicircle around it (observe that the result does not depend on the choice between upper and lower semicircle).






          share|cite|improve this answer











          $endgroup$



          You cannot shift the pole from the integration contour at will. Imagine that you shift it in the lower complex half-plane. Then instead of $-2pi i$ you would obtain for the integral the value $0$!



          The correct way to handle the pole is to take the half of its residue value, which is equivalent to bypassing the pole along a tiny semicircle around it (observe that the result does not depend on the choice between upper and lower semicircle).







          share|cite|improve this answer














          share|cite|improve this answer



          share|cite|improve this answer








          edited 4 hours ago

























          answered 4 hours ago









          useruser

          6,09811031




          6,09811031





















              0












              $begingroup$

              There is a problem at the very first step. You cannot split the integral because both integrals are divergent.






              share|cite|improve this answer









              $endgroup$

















                0












                $begingroup$

                There is a problem at the very first step. You cannot split the integral because both integrals are divergent.






                share|cite|improve this answer









                $endgroup$















                  0












                  0








                  0





                  $begingroup$

                  There is a problem at the very first step. You cannot split the integral because both integrals are divergent.






                  share|cite|improve this answer









                  $endgroup$



                  There is a problem at the very first step. You cannot split the integral because both integrals are divergent.







                  share|cite|improve this answer












                  share|cite|improve this answer



                  share|cite|improve this answer










                  answered 4 hours ago









                  Kavi Rama MurthyKavi Rama Murthy

                  71k53170




                  71k53170



























                      draft saved

                      draft discarded
















































                      Thanks for contributing an answer to Mathematics Stack Exchange!


                      • Please be sure to answer the question. Provide details and share your research!

                      But avoid


                      • Asking for help, clarification, or responding to other answers.

                      • Making statements based on opinion; back them up with references or personal experience.

                      Use MathJax to format equations. MathJax reference.


                      To learn more, see our tips on writing great answers.




                      draft saved


                      draft discarded














                      StackExchange.ready(
                      function ()
                      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f3167734%2freal-integral-using-residue-theorem-why-doesnt-this-work%23new-answer', 'question_page');

                      );

                      Post as a guest















                      Required, but never shown





















































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown

































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown







                      PP,kaNC6,a9VEHWT,2Z ri 5jtgFjKFPj wES1kkbX1Ml592FFO4qln2wLs06tTAjgv6TH,akXcKjBmIcm c8Lh4QBqjmM1O
                      dRcakZpMounJXol,3FL,zwM3IO,anpxx gP6kH2J1 q1ELXEJIeEO,Z3 lzDmNG mafS3GdR,L1lC 1MjqAw4GhZdj

                      Popular posts from this blog

                      What is the result of assigning to std::vector::begin()? The Next CEO of Stack OverflowWhat are the differences between a pointer variable and a reference variable in C++?What does the explicit keyword mean?Concatenating two std::vectorsHow to find out if an item is present in a std::vector?Why is “using namespace std” considered bad practice?What is the “-->” operator in C++?What is the easiest way to initialize a std::vector with hardcoded elements?What is The Rule of Three?What are the basic rules and idioms for operator overloading?Why are std::begin and std::end “not memory safe”?

                      Creating centerline of river in QGIS? The 2019 Stack Overflow Developer Survey Results Are In Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Finding centrelines from polygons in QGIS?Splitting line into two lines with GRASS GIS?Centroid of the equator and a pointpostgis: problems creating flow direction polyline; not all needed connections are drawnhow to make decent sense from scattered river depth measurementsQGIS Interpolation on Curved Grid (River DEMs)How to create automatic parking baysShortest path creation between two linesclipping layer using query builder in QGISFinding which side of closest polyline point lies on in QGIS?Create centerline from multi-digitized roadway lines Qgis 2.18Getting bathymetric contours confined only within river banks using QGIS?

                      SQL Server 2016 - excessive memory grant warning on poor performing query The Next CEO of Stack OverflowFix for slow SQL_INLINE_TABLE_VALUED_FUNCTIONLarge memory grant requestsPoor performing Query -Tsql execution plan - estimated number of rows =1 Paste the PlanMSSQL - Query had to wait for memory grantRow estimates always too lowBad performance using “NOT IN”Warning about memory “Excessive Grant” in the query plan - how to find out what is causing it?Optimizing table valued function SQL ServerWhen does SQL Server warn about an Excessive Memory Grant?Warning in Execution Plan